Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding redundant data
how can i see if i have two records in my spreadsheet that are the same? I
have over 60,000 rows of data. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200512/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding redundant data
One way ..
Assuming the key col is col A, with data in A2 down Use an empty col to the right, say col E Put in E2: =IF(A2="","",IF(COUNTIF($A$2:A2,A2)1,"x",1)) Copy E2 down to last row of data in col A Col E will return a "1" for the 1st instances of data in col A, "x" for any duplicates thereafter Do a Data Filter Autofilter on col E To see/filter out the duplicates, select "x" from the autofilter droplist in E1 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "eternal_cat via OfficeKB.com" <u14645@uwe wrote in message news:5883f36879898@uwe... how can i see if i have two records in my spreadsheet that are the same? I have over 60,000 rows of data. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200512/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding common Data in multiple worksheets | Excel Discussion (Misc queries) | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Finding min/max of adjacent data in a range of cells | Excel Worksheet Functions | |||
Finding, and returning data. | New Users to Excel |