| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match case
Hi,
I am trying to match 2 different sets/array of data and see if there will be any common digit. If there is a common digit I need a "YES" else a "NO". I am using MS Office 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match case
We need more info. Show us some sample data, tell us which ones meet your
definition of matching. For example 1 3 4 78 2 3 1 23 Is there one match here 3=3 are there 2 matches here 3=3 and 1=1 (they are in a different place) are there 3 matches here 3=3, 1=1 and 3=23 because 3 is a matching digit? -- Thanks, Shane Devenshire "taskmaster" wrote: Hi, I am trying to match 2 different sets/array of data and see if there will be any common digit. If there is a common digit I need a "YES" else a "NO". I am using MS Office 2003. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match case
Hi Shane The first two hold good..they can be in the same place or different places. Say Set1 Base Set 12 23 23 24 24 25 56 26 Set1 has 2 matches (23 & 24) when compared to Base set though in different places. Thank you! "ShaneDevenshire" wrote: We need more info. Show us some sample data, tell us which ones meet your definition of matching. For example 1 3 4 78 2 3 1 23 Is there one match here 3=3 are there 2 matches here 3=3 and 1=1 (they are in a different place) are there 3 matches here 3=3, 1=1 and 3=23 because 3 is a matching digit? -- Thanks, Shane Devenshire "taskmaster" wrote: Hi, I am trying to match 2 different sets/array of data and see if there will be any common digit. If there is a common digit I need a "YES" else a "NO". I am using MS Office 2003. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match case
Hello there!!
Can anyone help on this?? "taskmaster" wrote: Hi Shane The first two hold good..they can be in the same place or different places. Say Set1 Base Set 12 23 23 24 24 25 56 26 Set1 has 2 matches (23 & 24) when compared to Base set though in different places. Thank you! "ShaneDevenshire" wrote: We need more info. Show us some sample data, tell us which ones meet your definition of matching. For example 1 3 4 78 2 3 1 23 Is there one match here 3=3 are there 2 matches here 3=3 and 1=1 (they are in a different place) are there 3 matches here 3=3, 1=1 and 3=23 because 3 is a matching digit? -- Thanks, Shane Devenshire "taskmaster" wrote: Hi, I am trying to match 2 different sets/array of data and see if there will be any common digit. If there is a common digit I need a "YES" else a "NO". I am using MS Office 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change data of entire column from small case to upper case | Excel Worksheet Functions | |||
| Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
| Getting a case sensitive match? | Excel Worksheet Functions | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| can vlookup be forced to make a case sensitive match? | Excel Discussion (Misc queries) | |||
Linear Mode
