Compare List Summary of Results
I have successfully compared the first 10 digits of 2 lists in columns next
to each other to return a true or false answer using this formula in the c column. =ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0)) I need to now take the the number from column A that produced a false in column c and give me a list of the false answers in a diffenct column. I would apprecaite any help. Mike |
Compare List Summary of Results
Do you mean the below..If not post few examples
=IF(ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0)), "",A2) If this post helps click Yes --------------- Jacob Skaria "mikew" wrote: I have successfully compared the first 10 digits of 2 lists in columns next to each other to return a true or false answer using this formula in the c column. =ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0)) I need to now take the the number from column A that produced a false in column c and give me a list of the false answers in a diffenct column. I would apprecaite any help. Mike |
Compare List Summary of Results
How about a simple if statement?
=if(C1=FALSE,A1,"") -- Rob Gaffney "mikew" wrote: I have successfully compared the first 10 digits of 2 lists in columns next to each other to return a true or false answer using this formula in the c column. =ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0)) I need to now take the the number from column A that produced a false in column c and give me a list of the false answers in a diffenct column. I would apprecaite any help. Mike |
Compare List Summary of Results
Thank you Jacob,
I thought that there was a way to get a list of all the numbers to go to the top of the next column without having to scroll throught the whole list. I tried some indexing formulas, but I could not get them to work right, and I wasn't sure if that was what I needed. Thanks, Mike "Jacob Skaria" wrote: Do you mean the below..If not post few examples =IF(ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0)), "",A2) If this post helps click Yes --------------- Jacob Skaria "mikew" wrote: I have successfully compared the first 10 digits of 2 lists in columns next to each other to return a true or false answer using this formula in the c column. =ISNUMBER(MATCH(LEFT(A2,10)&"*",B$2:B$1201,0)) I need to now take the the number from column A that produced a false in column c and give me a list of the false answers in a diffenct column. I would apprecaite any help. Mike |
All times are GMT +1. The time now is 10:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com