View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ttbbgg
 
Posts: n/a
Default 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?