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...
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...
CountIf limitation
CountIF function cannot search for text longer than 255 chars. This is mainly found here … https://support.office.com/en-us/article/COUNTIF-function-E0DE10C6-F885-4E71-ABB4-1F464816DF34...
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...
Count cells with condition – multiple conditions
We did see who we can get total of a column for a certain month in certain year using SUMIFS. SUMIFS got a sister function,...