Median for Visible cells only

[Celticshadow]

Hi Everyone

May I ask the board if it is possible to have a formula for the visible cells only, that would portray the median of a column of cells.

Regards

 

[RickXL]

Hi

The AGGREGATE function will do that. For example:

=AGGREGATE(12,1,A2:A30)

See here for details: MS Excel: AGGREGATE Function (WS)