0% interest promotion
The past few months, I established a formula to help me determine if certain credit card promotion makes sense or not. This helped me a...
VALUE() of LEFT()
I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes...
Schedule column
Create list of dates excluding weekends and holidays.Basically create list of workdays in a certain year, you may fill in to get more. List of...
GoLast to jump to last cell in a column
Edit 2021-07-12: I needed this formula to work in a worksheet having space in its name, so original one did not work, here is the...
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...
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...
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...