Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 4th 05, 10:57 PM
Diamonds_Mine
 
Posts: n/a
Default IF and ISERROR Functions

In Excel 2003, I have a list of names in column A and column C; I need to
find any duplicates between the two columns. Column A has 469 rows and
Column C has 4713 rows. Example -- Column A -- Duck Donald and Column B --
Duck Donald

I found the formula below and it does work, but I need to know if I can use
a wildcard character in this formula to also find for instance: in Column A
-- Duck Donald and in Column B -- Duck Donald D. The difference being the
middle initial D. Any suggestions are greatly appreciated.

=IF(ISERROR(MATCH(A10,$C$1:$C$4713,0)),"",A10)

  #2   Report Post  
Old April 5th 05, 05:20 AM
Biff
 
Posts: n/a
Default

Hi!

Yes, you can use wildcards with MATCH:

=IF(ISERROR(MATCH("*"&A10&"*",$C$1:$C$4713,0)),"", A10)

Biff

-----Original Message-----
In Excel 2003, I have a list of names in column A and

column C; I need to
find any duplicates between the two columns. Column A

has 469 rows and
Column C has 4713 rows. Example -- Column A -- Duck

Donald and Column B --
Duck Donald

I found the formula below and it does work, but I need to

know if I can use
a wildcard character in this formula to also find for

instance: in Column A
-- Duck Donald and in Column B -- Duck Donald D. The

difference being the
middle initial D. Any suggestions are greatly

appreciated.

=IF(ISERROR(MATCH(A10,$C$1:$C$4713,0)),"",A10)
.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:15 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017