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
CountIf limitation
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
CHOOSE – tree of decisions
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 …
Count Unique
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 …
DayName
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 …
Fixed length ID
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 …