Personally, I would still use the lookup table. You have to type the 50
entries only once.

However, if for some reason you insist on another solution, it won't be
easy. You can scan for "Adult" and "Couple" pretty easily (using Countif for
example). For "Children", you need to do a Find to determine whether it's in
the cell, then back up one or two characters from that position to determine
the number.

Regards,
Fred

"Fab" wrote in message
news
Okay let me clarify a bit there needs to be 50 arguements in this formula
as
there are 50 different types of Family Compliments ranging from:

Single Adult - which would equal 1 through to
Couple + 10 Children - which would equal 12



"ozgrid.com" wrote:

Use a Lookup table
http://www.ozgrid.com/Excel/lookup-table.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Fab" wrote in message
...
Okay here we go.

I need to create a Conditional Formula that

1. Identifies the words i.e. Single Adult or Single Adult + 1 Child and
then
returns the number 1 or 2.

This is so I can count the people. With me so far.

Here is the issue

I have 50 Different Family Compliments (Single Adult) to do this on and
need
a formula that can handle it.

HELP - I can e-mail the spreadsheet if you need it.