Forum Discussion
Counting unique values across multiple tabs
Hello. I'm trying to write a formula but am having no luck - help please. I would like to count all unique values (these are client id numbers) in column A across multiple sheets (only counting...
=SUM(N(IF(NOT(ISBLANK(B5:B31)),MATCH(IF(NOT(ISBLANK(B5:B31)),A5:A31),IF(NOT(ISBLANK(B5:B31)),A5:A31),)=ROW(A1:A27))))You can try this formula for your changed requirement. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.