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 archive.
Tag: CountIF
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 holidays is defined in another column, formula already excludes Saturdays and Sundays.
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 …