Search across sheets in function
Just when you need to search for a thing across sheets in a workbook. I am bored, so I am adding articles from my old...
Min Max vehicle
Finding which vehicle with minimum (or maximum) amount of savings among peers. This is an old request, found its formula in my archive to calculate...
The Excel “&” bug
Just a quick find I noticed few days ago. If you notice, the & inside cell has turned into an underline of the letter after...
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...