ExcelBanter - Finding matches (in Excel 2007)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Finding matches (in Excel 2007) (https://www.excelbanter.com/excel-discussion-misc-queries/161371-finding-matches-excel-2007-a.html)

GARY

Finding matches (in Excel 2007)

Col A has 2500 cells and Col B has 1 million cells.

How can I find the cells in Col A whose contents exactly match those
in Col B?
How should the formula be written?

Peo Sjoblom

Finding matches (in Excel 2007)

No need to post more than once

--

Regards,

Peo Sjoblom

"GARY" wrote in message
ups.com...
Col A has 2500 cells and Col B has 1 million cells.

How can I find the cells in Col A whose contents exactly match those
in Col B?
How should the formula be written?

All times are GMT +1. The time now is 12:59 PM.