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.
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 …
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 it is …
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, COUNTIFS Which will count how …