"Carim" wrote:

Hi,

Could you share with us the formula, to make appropriate suggestions
....

Cheers

Carim



=ISNA(MATCH(D2,$P$2:$P$2500,FALSE))

is the formula that is in cell y2.

=ISNA(MATCH(P2,$D$2:$D$2500,FALSE))

is the formula that is in cell z2.

The formula checks to see if a sales receipt number from one list is on the
other. I use both lists, one from the store and one from company database,
to reconcile that month's sales.

I sum column E which is the total sales for the month to see how far off the
two reports are. When I find a sales receipt that needs to be added or
subtracted to one report or the other the total sales sum will get closer.
When they match I know that both lists contain the necessary sales receipts,
I know that I am through reconciling.

Some reports contain 3500 rows and others contain 5000+ rows.