GoLast to jump to last cell in a column
This dynamic Hyperlink cell with 1 complete formula will let you Go to first available cell in a column. To allow you to enter next row data.It can help you …
Standard functions that comes with Excel, plain single functions
This dynamic Hyperlink cell with 1 complete formula will let you Go to first available cell in a column. To allow you to enter next row data.It can help you …
CountIF function cannot search for text longer than 255 chars. This is mainly found here … https://support.office.com/en-us/article/COUNTIF-function-E0DE10C6-F885-4E71-ABB4-1F464816DF34
If you are like me, then you must have needed to use CHOOSE functionThis is basically like “SELECT CASE” statement, but more limited So, in few words, you can derive …
A question by a colleague on how to count number of unique items in a column made me realize, I don’t have that here.
So here it is …
Simplest way to get name of day as cell output from a date. Because you can custom format a cell with date to show only that day name This is …
I needed few months back to make a fixed-length ID iut if none-fixed-length numbers. SO I used the function REPT with RIGHT to force all numbers to be converted into …