Saturday, 21 November 2020

How to find the unique or distinct values in a column in excel

The formula is 


=SUM(1/COUNTIF(B4:B722,B4:B722))

Where B4:B722 are the values in the column. 

Remember to close it by ctrl+shift+enter

This is an extremely useful formula

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)