| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a value if a range of cells contain text
Hi,
Am Wed, 3 Oct 2012 08:53:34 +0000 schrieb the-chauffeur: I have a range of cells (B3,B5,B7,B9 and B11) that start out blank and are validated so users can only select one of 4 responses: <BLANK RED AMBER GREEN I want to put some kind of function in cell A2 so that if any one of the B range cells contains text, A2 shows Y - and if not, it's blank. try in A2: =IF(COUNTA(B3,B5,B7,B9,B11)0,"Y","") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#2
|
|||
|
|||
|
Quote:
Claus You're a genius - that's exactly what I was after. Thanks so much for your time. Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return the greatest value in a range of cells | Excel Discussion (Misc queries) | |||
| See if a range of cells contains certain text to return the value | Excel Worksheet Functions | |||
| Find value between range & return text | Excel Worksheet Functions | |||
| lookup and return range of cells | Excel Worksheet Functions | |||
| How do I return the highest value in a range of cells | Excel Worksheet Functions | |||
Hybrid Mode
