formulas and sorting

Autumn · Apr 29th, 2002, 10:01 AM

Does anyone know how to use a formula based on information that has been filtered as to not include the "filtered out" information?

Iain Lewis · Apr 29th, 2002, 10:11 AM

SUBTOTAL works on filtered info, though more info would be helpful.

Autumn · Apr 29th, 2002, 10:24 AM

I need to find the median and average for a column based on information in the column next to it. I filter the info based on column A but the formula includes all the info in B rather than just the filtered lines.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 10:01 AM	#1
Autumn New Member Join Date: Apr 2002 Posts: 8	Does anyone know how to use a formula based on information that has been filtered as to not include the "filtered out" information?

Apr 29th, 2002, 10:11 AM	#2
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	SUBTOTAL works on filtered info, though more info would be helpful.

Apr 29th, 2002, 10:24 AM	#3
Autumn New Member Join Date: Apr 2002 Posts: 8	I need to find the median and average for a column based on information in the column next to it. I filter the info based on column A but the formula includes all the info in B rather than just the filtered lines.