How to count unique values in excel
Hi Friends Today we are going to learn about how to count unique value in excel # 1 First we need to Catch Unique value in excel lets see the Excel table below for catch the unique value Follow the step one by one First, Select the work area of the column then select Data - > Advanced -> Select the Step 3-> Then press Unique record Only then press ok Result Output Then count the Unique Value simple Formula =COUNTIF(B2:B30,D2) Thanks By VASU