Category: Logical

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

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

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

I have seen this practice before several locations Returning multiple outputs in 1 single number. for example...

Tool will compare between two sheets using formula/functions method. Once you type in full folder locations (for both files), file names and sheets names in...

A simple calculator, how come we do not have one like this?...