Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Data -Adding information to another column in row & dele | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Finding last cell with data in a column | Setting up and Configuration of Excel | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
How to set up a column to accept changing data from 1 cell on ano. | Excel Worksheet Functions |