I have a workbook setup with 6 sheets: 5 for data and one that calculates the aggregate results.
In each worksheet I have a column that has a list of numbers. Sometimes, there are multiple instances of the same number across multiple worksheets, which skews the calculations. I have a formula for the individual worksheets already that counts unique values on each individual worksheet:
=SUMPRODUCT((C2:C102<>"")/COUNTIF(C2:C102,C2:C102&""))
I would just like to get something that does this across all of my worksheets. Any advice?
Bookmarks