Finding duplicate cell entries in a column of data
 

I have a spreadsheet, currently in a subtotalled format, of which under each
subtotal I need to be able to find a way of discounting duplicate entries.

Does anyone know of a way of doing this?

Any help gratefully appreciated.

Hi Ellie
One way would be to add a helper column .
Assuming the column with the duplicated data to be B then in the helper
column enter
=COUNTIF($B$1:B1,B1)
and copy down
DataFilterAutofilter and on the drop down for the helper column, choose 1
This will filter out all duplicates, and, SUBTOTAL will only total the
visible rows


--
Regards
Roger Govier
"Ellie" wrote in message
...
I have a spreadsheet, currently in a subtotalled format, of which under
each
subtotal I need to be able to find a way of discounting duplicate entries.

Does anyone know of a way of doing this?

Any help gratefully appreciated.