Forum Discussion

Copper Contributor

Jan 15, 2025

Need a formula to count unique values from one column based off of another column

Hello! This question is for a web-based Excel which I understand does not have all of the same features as a desktop Excel. I need to create a formula that counts unique values in one column (say...

Excel for web

Formulas and Functions

Kidd_Ip

MVP

Jan 16, 2025

Try below formula that can help to

=COUNTA(UNIQUE(FILTER(B:B, O:O = "Waiting")))

count the unique values in Column B based on the status in Column O

joeyspice

Copper Contributor

Jan 16, 2025

Thanks, Kidd_Ip! That appears to be working as expected. Hope you have an amazing day!