| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with vlookup results for summary | New Users to Excel | |||
| Compare and Return Results | Excel Discussion (Misc queries) | |||
| need to compare dates and count results | Excel Worksheet Functions | |||
| Want to compare EOY results | Excel Discussion (Misc queries) | |||
| compare results | Excel Discussion (Misc queries) | |||
Threaded Mode
