View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChrisR ChrisR is offline
external usenet poster
 
Posts: 8
Default count unique values in a filtered range

I would like a unique count to return in a filtered range the same way I have
a total returned using a subtotal function (Subtotal(9,range)). This would be
on a unique idenitier for each row. Is there any way to do this in a formula,
as I'd like this to be easy to use for others? I don't want to use the
Advanced filter.