In my excel sheet ,there are so many names in different cells.how we will create an equation if one name is exist in sheet?for exampl in sheet the name RAMU exist two or three times.but it should be count as one by using eqation.is it possible?
In my excel sheet ,there are so many names in different cells.how we will create an equation if one name is exist in sheet?for exampl in sheet the name RAMU exist two or three times.but it should be count as one by using eqation.is it possible?
To count unique values you could use:
Formula:Please Login or Register to view this content.
BSB
Another way
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks