| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When using Autofilter on Excel, how do I ignore 1st 1 or 2 rows
To follow up, John emailed me directly asking how to treat
=COUNTA(D3:D29) and =AVERAGE(H3:H29) in a similar way. There are a number of functions that can be used with SUBTOTAL(x,range) - some of the common values of x a 1 - AVERAGE 2 - COUNT 3 - COUNTA 4 - MAX 5 - MIN 9 - SUM You can use Help - SUBTOTAL_worksheet_function to find the other values. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Isolate rows based on highlight (Excel 2003) | Excel Worksheet Functions | |||
| How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) | |||
| change excel row height without showing hidden rows | Excel Worksheet Functions | |||
| Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
| How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
