| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count / match
Hi,
Column A Column B John = return value of 1, if matches, else 2 John Smith Bob I like to have a formula in column b, if item in A1, "John" matches any item in column A, then show value of #1, else, #2 Any help? THANKS! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count / match
Maybe this:
=2-(COUNTIF(A$2:A$10,A2)1) -- Biff Microsoft Excel MVP "Rachel" wrote in message ... Hi, Column A Column B John = return value of 1, if matches, else 2 John Smith Bob I like to have a formula in column b, if item in A1, "John" matches any item in column A, then show value of #1, else, #2 Any help? THANKS! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match wild cards and then count | Excel Discussion (Misc queries) | |||
| How to count the match letter within a string? | Excel Discussion (Misc queries) | |||
| Match and Count duplicate names | Excel Worksheet Functions | |||
| Count if match any of 3 strings | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
Linear Mode
