comparing two list and need to find exact in both lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bill - 14 Sep 2007 17:08 GMT

I need to compare the data in todays list and see if it was in yesterdays
list and if so bring back a true otherwsie false value

Reply to this Message

Gary''s Student - 14 Sep 2007 17:58 GMT

Put today's data in column A and yesterday's data in column C.

In column B, enter:
=COUNTIF(C1:C10,A1)>0 and copy down

Here is an example:

3    FALSE    2
10    TRUE    6
1    FALSE    5
9    TRUE    10
9    TRUE    6
7    FALSE    9
6    TRUE    2
5    FALSE    6
8    TRUE    4
8    TRUE    8

Signature

Gary''s Student - gsnu200744

> I need to compare the data in todays list and see if it was in yesterdays
> list and if so bring back a true otherwsie false value

Reply to this Message