How to count unique values in Excel

11 months ago

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

Loading comments...