ExcelBanter - compare the contents of one range of cells with the contents of a.

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

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

- - compare the contents of one range of cells with the contents of a. (https://www.excelbanter.com/excel-discussion-misc-queries/127448-compare-contents-one-range-cells-contents.html)

Dozy123

compare the contents of one range of cells with the contents of a.

I have two lists of names in two different excel spreadsheets. How can I
compare the lists to see if any names are on both?

Mike

compare the contents of one range of cells with the contents of a.

use conditional formatting as described at

http://j-walk.com/ss/excel/usertips/tip073.htm

"Dozy123" wrote:

I have two lists of names in two different excel spreadsheets. How can I
compare the lists to see if any names are on both?

All times are GMT +1. The time now is 10:13 AM.