| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is data in two character fields the same?
I am trying to compare the contents of two character fields (names) to see if
they are the same. How can I do that? Thanks, -- Ted |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is data in two character fields the same?
=IF(A1=B1,"Match","No Match")
This is case insensitive. If you need a case sensitive match, use =IF(EXACT(A1,B1),"Match","No Match") Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 31 Jan 2009 14:34:05 -0800, Ted @ PMI wrote: I am trying to compare the contents of two character fields (names) to see if they are the same. How can I do that? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Switch to change data fields to 0's, then back to original data? | Excel Discussion (Misc queries) | |||
| Character limitations for excel fields | Excel Worksheet Functions | |||
| Adding multiple data fields from time based data. | Excel Discussion (Misc queries) | |||
| how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Hybrid Mode
