Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter function, how many rows are returned setting in Excel.
THere is a setting that indicates how many rows are returned when the filter
function is used. How do I turn that setting on ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter function, how many rows are returned setting in Excel.
There is no setting to turn on or off.
See Debra Dalgleish's site for info and workarounds. http://www.contextures.on.ca/xlautofilter02.html#Count Gord Dibben MS Excel MVP On Thu, 13 Dec 2007 10:45:02 -0800, Mike _Powell <Mike wrote: THere is a setting that indicates how many rows are returned when the filter function is used. How do I turn that setting on ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter setting | Excel Worksheet Functions | |||
lookup with multiple rows returned | Excel Discussion (Misc queries) | |||
Excel, function, result to be returned in another designated cell | Excel Worksheet Functions | |||
Using Excel's Auto Filter, how can I show # of records returned? | Excel Worksheet Functions | |||
Find the number of rows returned in a filter | Excel Discussion (Misc queries) |