| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maybe an array is needed?
Morning,
I have eight cells that return a text message if certain conditions are met. Those eight cells have a named range, Range_1. Currently the formula I have tests just one cell for that string; =IF(G20=msg, "XXX", ""). I would like to enhance this formula to test if any of the cells in Range_1 result in that string (a named range msg), and if so display a more detailed message now €œXXX€, elsewhere. I am trying to work through an array, currently unsuccessfully. Sincerely, Arturo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| defintion of array function | Excel Discussion (Misc queries) | |||
| How to multiply all cells in array by factor | Excel Discussion (Misc queries) | |||
| Array formula expertise needed | Excel Worksheet Functions | |||
| Transpose words and numbers into array of different proportions | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
