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