Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Ok, i need some help.
I have two columns of data. For one of the columns, i need to find out if its contained somewhere, anywhere in the other column. So how was going to do it was useing an ISNA, Match function and create a new column called Missing?, and then drag the code down, if its not contained then it will output True, if it is there, then it will output False. This usually works great. The only problem im having is that my column contents are kinda wacky. Here are some examples M4758375 12-67-8 056-76-23 08-22-456 So both columns have data like this. And for some reason, my ISNA code isnt working. Any ideas? Thanks, -Adam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If isna match vlookup formula | Excel Worksheet Functions | |||
VLOOKUP and LEN/ISNA to match names? | Excel Worksheet Functions | |||
ISNA(MATCH...) and IF functions - can they be combined? | Excel Worksheet Functions | |||
IsNA(match | Excel Worksheet Functions | |||
IsNA(match | Excel Worksheet Functions |