Hi!
How do you determine which dollar amount is correct?
ID AMT
xx 100
xy 200
xx 102
aa 110
xx 100
xx 102
xx 150
Which amount for xx is correct?
Biff
-----Original Message-----
I'm trying to figure out if there is a formula that will
compare the values
in column E, based on the values in column A. In column
A the values are a
persons ID number, and that number can be repeated on
multiple rows. The
values in column E are dollar amounts. The dollar
amounts for each persons
ID should be the same, but they all aren't. I'm trying
to figure out a
formula that compares the dollar amounts in column E for
each person's ID
number, and tells me if one of the dollar amounts is not
equal. Maybe
have it return some sort of Identifier, so I can just do
an autofilter and
see all the ones that don't equal.
--
--
Brendan
.
|