View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neolyth Neolyth is offline
external usenet poster
 
Posts: 1
Default Mode Function combined with a filter

Hi
I'd like to use the mode-function like sumifs or countifs. So first I want
to do a filtering and then use the resulting list to calculate the modal
value. How can I do this?

Thanks in advance