On 5/6/08 2:21 PM, in article
DA4863FE-6F03-4CBA-96B4-186EBD1F72D0@[EMAIL PROTECTED]
"bill_jba"
<bill_jba@[EMAIL PROTECTED]
> wrote:
> 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
>
>
You need a macro to do exactly what you want. However, you can use several
manual steps to locate the data. I would create 2 additional columns to
the
right. In the first column place the formula "=a1&b1 assuming the order
number is in column A and the price in column B. then in the next Colum,
put
in sequential numbers representing the row. Then sort the whole mess on
the
column with the combined order numbers and row number. You could then
enter
a formula in the next column to the right beginning in row 2 for example
that looks like =x2=x1. Then search for TRUE and you'll have your
duplicates.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
|
