I have a total of six columns divided in to 3 columns. Each column has a number in it. I need a formula to tell me which number from the 2nd 3 columns match the number or numbers from the 1st 3 columns.
EX.
123 367 ..... the #3 is a match. the number 3 is in the 1st position. I need a column to relay this information
Last edited by Jordans121; 02-21-2010 at 11:15 PM.
is this a row by row thing? You want to know which of the 2nd 3 match any of the first 3? You want it to say it is in the 1st posiition? What if there is more than 1 match?
This formula will tell you the first number in D1:F1 to match numbers in A1:C1, if any, if no match, N/A error returned.
=MATCH(TRUE,INDEX(ISNUMBER(MATCH(D1:F1,A1:C1,0)),0),0)
Last edited by NBVC; 02-21-2010 at 10:49 PM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Yes this is row by row. Correct. I want it to say "1" for the 1st postion, "2" for the 2nd postion.....etc. If there is more than 1 match I would like it to say "12", or 13, or 23 if possible
The first six columns (a,b,c,d,e,f) contain the numbers column G has a separate formula for a different reason. H and so on are all unused
Then try:
=IF(ISNUMBER(MATCH(D1,A1:C1,0)),1,"")&IF(ISNUMBER(MATCH(E1,A1:C1,0)),2,"")&IF(ISNUMBER(MATCH(F1,A1:C1,0)),3,"")
Yesssss!!! Thankyou
There is only one problem. how do I get this formula to work from row 20 and beyond?
What exactly do you mean?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks