Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicates Excel 2000
=IF(NOT(G2=G3), "No Duplicate")
I am using the above formula with a huge list. I have false on one of the duplicates but would like to have false on both duplicates as I want to sort all the false ascending to remove them at one time. Thanks Linda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicates Excel 2000
Try it with this:
=IF(COUNTIF(G:G,G2)1,"Duplicate","unique") then copy down. No need to sort the list to get rid of the duplicates - apply Autofilter to the column with the formula and choose Duplicate from the filter drop-down. Then highlight all the visible rows and click on Edit | Delete Row. Choose All from the filter drop-down to see your remaining Unique values. Hope this helps. Pete On Aug 26, 2:10*pm, Dendy wrote: =IF(NOT(G2=G3), "No Duplicate") I am using the above formula with a huge list. *I have false on one of the duplicates but would like to have false on both duplicates as I want to sort all the false ascending to remove them at one time. Thanks Linda |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicates Excel 2000
Use COUNTIF instead, comparing individual entries in G to the entire list.
Assuming your huge list goes from row 2 to 295, then try this as the formula in row 2 and fill down: =IF(COUNTIF(G$2:G$295,G2)=1,"No Duplicate") "Dendy" wrote: =IF(NOT(G2=G3), "No Duplicate") I am using the above formula with a huge list. I have false on one of the duplicates but would like to have false on both duplicates as I want to sort all the false ascending to remove them at one time. Thanks Linda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) |