Posted to microsoft.public.excel.worksheet.functions

Neolyth

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table value filter combined with Top x functionality not wor	Ram	Excel Discussion (Misc queries)	0	October 29th 08 06:56 PM
copy in filter mode	Sarah	Excel Worksheet Functions	0	October 8th 07 07:07 PM
Filter mode	Julieeeee	Excel Worksheet Functions	1	July 29th 05 06:41 PM
Why does it say "Filter mode" instead of "X of Y records"?	lucky_jed	Excel Worksheet Functions	3	April 7th 05 12:05 PM
copy in filter mode		Excel Worksheet Functions	1	January 8th 05 03:36 AM

All times are GMT +1. The time now is 03:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us