Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match
Hi
I've got 2 columns of data and want to find out if a value in col A exists anywhere in column B - I thought the match function might do this but I can't work it out. Thanks Anita |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match
=ISNUMBER(MATCH(A2,B:B,0))
will return TRUE or FALSE -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Anita" wrote in message ... Hi I've got 2 columns of data and want to find out if a value in col A exists anywhere in column B - I thought the match function might do this but I can't work it out. Thanks Anita |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match
Anita,
Lots of methods fo duplicates he- http://www.cpearson.com/excel/Duplicates.aspx Mike "Anita" wrote: Hi I've got 2 columns of data and want to find out if a value in col A exists anywhere in column B - I thought the match function might do this but I can't work it out. Thanks Anita |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match
=IF(ISNA(MATCH(A1,B:B,0)),"Not found","Found")
-- David Biddulph "Anita" wrote in message ... Hi I've got 2 columns of data and want to find out if a value in col A exists anywhere in column B - I thought the match function might do this but I can't work it out. Thanks Anita |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match
Hi Anita,
You can do this by using COUNTIF function, Please find the below example: ColA ColB ColC RAJ RAJ 1 RAM KUMAR 1 KUMAR RAJ 1 JOHN MIKE 0 Forumula used in cell C1 is as follows =COUNTIF($A$1:$A$4,B1) If a value in Col A is also there in Col B then it will display value '1' in ColC, otherwise (i.e value in col B is not in col A) it will display value '0' in column C. Hope this will clear your doubt. Regards, Soundar. "Anita" wrote: Hi I've got 2 columns of data and want to find out if a value in col A exists anywhere in column B - I thought the match function might do this but I can't work it out. Thanks Anita |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions |