how do you find a cell equal to a cell from another list

G

Guest

I have 2 lists & I would like to be to identify data that is in both lists so
that I can delete non relevant data & then combine the data from the 2 lists
into one list
 
G

Guest

Thank you very much, I have been trying to work out how to do that for years,
although I have not yet got the formula to work I'm sure I will
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

identify list used in a cell 2
Macro: finding a cell on one worksheet and copying to another worksheet 0
Sorting cells: a list behind the cells do not move with the cell 2
How to determine the value - 18 Dec? 5
Restrict choices in one drop down list by response to another 4
how do i sort 2 colums so that the same values line up 1
Generate a List By a Condition 1
how do I use one drop-list to modify another drop-lists options? 3

Top