Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have 60,000 rows from an ODBC strip that has UPC codes in column A and SKU
numbers in column B (sorted by column A). Each row is a location record. I am looking for UPC codes that 'point' to different SKU numbers and would like to delete the rows that are correct. So .... I want to look in column A - and for as many rows as this value is the same (may be 1 to 20 rows) .... I want to look at column B - and if all column B entries for the same rows are also equal I want to delete that block of rows. If there are different SKU values in column B I want to keep that entire block of rows. Then on to the next UPC .... etc., etc. I know the logic I'm looking for ... just don't know how to explain it to my machine! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I compare 2 columns in excel from the same spreadsheet | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Compare Columns | Excel Discussion (Misc queries) | |||
Compare two columns | Excel Discussion (Misc queries) | |||
compare columns of different worksheets | Excel Discussion (Misc queries) |