Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic subtotals and eliminate dupes
Working with a large spreadsheet. I will engage Autofilter and want to add a
section at the bottom for subtotals pertaining to the filtered data shown. What formula(s) would I use for that since it would change for each filter selection? Also, I want to put in a dynamic count for an array, however there will be duplicates. How do I eliminate a count with dupes in an array? |