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