Matching data

[LaserDance]

Hi folks.

In column A, I have a huge ammound of data. In column B I also have a big ammount of database. How can I compare the matching items in both and those who match to be displayed in the column C.
*The data in A and B are not in the same order, I mean when I say "matching" it does not mean that the same data should be at one and the same row.

Thanks

[LaserDance]

Nobody knows .... ?

[TMS]

Use Conditional Formatting with the "Formula is" option.

For the cell A2, the formula would be: =COUNTIF($B:$B,$A2)>0. Copy the format to the other cells in column A.

Pick a format: bold text or red text or red background or whatever.

Similarly for Column B: Cell B2 CF condition is =COUNTIF($A:$A,$B2)>0

Regards

[LaserDance]

No, that is not what I want. I obviously didn't explain very well what I want. Here is an exampe:
A1:WA458 B1:TR298
A2:WM940 B2:WR509
A3:WS208 B3:WM940
A4:WR509 B4:QA666

As you can see, only WM940 and WR509 match, even though they are not in the same row.
I just need a formula showing me which items from column B do match with the same items in column A.

Thanks

[TMS]

Did you try to use the Conditional Formatting?

Maybe not? No worries ... you could just use those formulae in columns C and D, for example.

For example:

Please Login or Register  to view this content.

Regards