count / match

's Computer Specifications

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!

's Computer Specifications

Maybe this:

=2-(COUNTIF(A$2:A$10,A2)>1)

--
Biff
Microsoft Excel MVP

"Rachel" <(E-Mail Removed)> wrote in message
news:FE77A57E-FE16-4723-B027-(E-Mail Removed)...
> 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!
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count or Match Help Please	Paul Black	Microsoft Excel Programming	2	13th Jul 2011 11:15 PM
count and match	Pammy	Microsoft Excel Misc	3	18th Nov 2009 05:00 PM
how to match multiple columns with multiple rows and count their match	chronicels	Microsoft Excel Worksheet Functions	0	31st Jan 2008 07:39 PM
Count if match any of 3 strings	GGG	Microsoft Excel Worksheet Functions	2	8th Dec 2005 11:14 PM
Sum-Count-Offset-IF- Match	QTE	Microsoft Excel Worksheet Functions	6	16th Jul 2004 02:36 PM