Category: Standard functions

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...

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...

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...

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...

This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time...

Using formulas to repeat list, I call it LoopList Used to list Months for several years, in away that with 1 formula, it will loop...