Hi,
You can use a Pivot table to get unique names.
Please let me know if this answers your query
Thanks
Prashanth
On Sun, Feb 6, 2011 at 7:15 PM, niru wrote:
> I have one query for one database. I have few numbers of names i want
> to count that. if there are 1 name nitin repeated 5 time and
check out the link
http://office.microsoft.com/en-us/excel-help/count-occurrences-of-values-or-unique-values-in-a-data-range-HP003056118.aspx
On Sun, Feb 6, 2011 at 7:15 PM, niru wrote:
> I have one query for one database. I have few numbers of names i want
> to count that. if there are 1 na
I have one query for one database. I have few numbers of names i want
to count that. if there are 1 name nitin repeated 5 time and one name
repeated 6 time but i want count that as only one name dont want
duplicate value
--
-
