Search across sheets in function
July 22, 2022
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.
=COUNTIF(OFFSET(INDIRECT(ADDRESS(1,1,1,,C$4)),0,0,65536,255),Search_Result!$B5)