| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting Problem
Does anyone know how I can get information from a range of cells more than
nine rows? Example If a name shows up within a few ranges from range 1 D9 through D20 and or range 2 D30 through D50 and or range 3 D60 through D80 then enter whatever is in cell a5. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nesting Problem
One way, in say, B5:
=IF(OR(COUNTIF(D9:D20,"Name"),COUNTIF(D30:D50,"Nam e"),COUNTIF(D60:D80,"Name")),A5,"") -- Max Singapore http://savefile.com/projects/236895 Downloads:17,700 Files:359 Subscribers:55 xdemechanik --- "Ed Davis" wrote: Does anyone know how I can get information from a range of cells more than nine rows? Example If a name shows up within a few ranges from range 1 D9 through D20 and or range 2 D30 through D50 and or range 3 D60 through D80 then enter whatever is in cell a5. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HLP! Nesting Problem?? | Excel Worksheet Functions | |||
| IF Function Nesting Problem | Excel Worksheet Functions | |||
| Another Nesting IF Statement Problem | Excel Worksheet Functions | |||
| Nesting Problem | Excel Worksheet Functions | |||
| nesting sum if and | Excel Worksheet Functions | |||
Linear Mode
