How to count unique values in Excel

Hello, My Dear Friends, !! In this video, I will show you How to count unique values in Excel. Watch the video till the end Thanks.

Step 1: Select the range of cells, or make sure the active cell is in a table. 

Step 2: On the Data tab, in the Sort & Filter group, click Advanced. 

Step 3: Click Copy to another location.

Step 4: In the Copy to box, enter a cell reference.

Step 5: Select the Unique records only check box, and click OK.

Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel.

#initial #solution #count #unique #values #in #excel