Duplicated data

[fakhteh]

Hi
i want to count the data record and some of them are duplicated so how can i omit and delete one of these duplicated data with formula
thanks

[canapone]

Hi,

a possible approach could be:

Please Login or Register  to view this content.

Regards

[canapone]

Hi,

the following formula is maybe more general:

Please Login or Register  to view this content.

Regards

[Amanda Wilso]

Data|Filter|Advanced filter

Select copy to another location
Check Unique records only
Select a range to copy to which should be a single cell
OK and you get a list of unique items.

In C2 enter this formula
=COUNTIF($A$2:$A$16,C2)
Drag down to the length of the filtered list.