Hello all,
I have a relatively simple issue. I have 3 columns of 50 numbers each; the numbers are non-sequential and may as well be random.
I need to identify the 'common numbers': which numbers appear in all 3 columns. This can be displayed anywhere, really, I just need a quick way of doing it.
Thanks very much for your help!
Put this formula in D1 and copy down to D50. All the numbers in column A that exist in columns B and C will appear.
=IF(AND(ISNUMBER(MATCH(A1,B:B,0)),ISNUMBER(MATCH(A1,C:C,0))), A1, "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Here's a shrinky dink example:
With this list in A1:C10..and assuming no blank cells
This section defines the list of unique numbers in ascending order
Please Login or Register to view this content.
Copy E3 down as far as you need...through E15 in this casePlease Login or Register to view this content.
This section flags the numbers in that list that occur in all three columns:
Copy F2 down through F15Please Login or Register to view this content.
Since numbers 10 and 13 are the only ones that occur in all 3 columns,
this is the final listing:
Is that something you can work with?Please Login or Register to view this content.
I don't have access to Excel outside of work, but these both look to be great solutions. I'll update with results, thanks very much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks