I have 4 lists of names in excel, and I need to find out what names show up on all 4 lists. Anyone know how?
-
Basically I have 4 lists of data in Excel, I need to export the names that show up in all four lists..
-
Answer:
Let's say your four lists are in A1:D10. This formula will look at the value in A1 and determine if it is also found in each of the other columns (B1:B10, C1:C10, D1:D10). =IF( OR( ISNA( MATCH( A1, $B$1:$B$10, 0)), ISNA( MATCH( A1, $C$1:$C$10, 0)), ISNA(MATCH( A1, $D$1:$D$10, 0))), "no", "yes") Copy this formula and paste it down as far as it needs to go. Then, export those names in column A that have a corresponding "yes".
Arosenb4... at Yahoo! Answers Visit the source
Related Q & A:
- Does anyone know how I can get bruins tickets and train tickets as a package deal and where I could do this?Best solution by Yahoo! Answers
- I need to find the exact location of the factory amplifier in a 2004 Porsche Cayenne.Best solution by Yahoo! Answers
- I need to find the name of a commercial.Best solution by Yahoo! Answers
- Does anyone know how I can get a scholarship to study abroad?Best solution by usnews.com
- Does anyone know how I can get a football trial?Best solution by answers.yahoo.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.