| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions to ignore hidden rows
I want the functions MATCH, INDEX, and AVERAGE to ignore hidden rows, for the
data range specified. In addition, worksheet functions containing MATCH will be named, and names inserted in INDEX. (I have found that, when specifying data ranges for charts, using names often negates the hiding of rows). Can it be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore page breaks for hidden rows | Excel Discussion (Misc queries) | |||
| Ignore Hidden Rows on Sum Function on Excel XP | Excel Discussion (Misc queries) | |||
| How do you ignore hidden rows in a countif() function | Excel Worksheet Functions | |||
| How do I ignore values while copying from hidden rows? | Excel Worksheet Functions | |||
| Ignore Hidden Rows in Sum Function? | Excel Discussion (Misc queries) | |||
Threaded Mode
