LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fab fab is offline
external usenet poster
 
Posts: 6
Default Conditional Formula Words

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formula with Words and different columns Misplaced Mainer Excel Worksheet Functions 5 August 21st 09 04:55 PM
Conditional formatting - Numbers and words Mark Andrews Excel Discussion (Misc queries) 1 June 18th 09 06:14 AM
changeing words conditional?? please help laandmc Excel Discussion (Misc queries) 3 August 27th 08 01:17 PM
Conditional formatting by key words RichG Excel Worksheet Functions 4 November 19th 07 08:40 PM
conditional formatting on words [email protected] Excel Discussion (Misc queries) 11 June 5th 06 05:56 PM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"