I have a row of data containing 2 inseparable and related columns that I
want
to compare with all other data rows.
The first column contains an order #, which could contain text and numbers
and in the same row, is the second related column, which contains an
amount
in $.
I want to create a formula to search the data file, which contains more
than
5,000 rows, to determine if the same order # and the same amount together,
appear in the data more than once.
If the result finds a duplicate, I want the entire row to be highlighted
and
an separated from the data if possible into a new sheet, with out cut and
pasting.
Thanks in advance for the assistance
|
