need a formula

[RSEKAR]

Dear Sir,
I have a filtered table containing numerical data in R column (R10:R949). I need a Formula to find out the Minimum value in R column among the filtered list.
Thanking you in advance.

 

[jim may]

From the dropdown arrow on Col R - Look for Top 10...
Select it then from dropdown, chg Top to Bottom, enter 1 in next textbox and
Item in Last textbox.

 

[AlphaFrog]

The Subtotal function works on filtered cells and it will return a Minimum among other things.

=SUBTOTAL(5, R10:R949)

 

[RSEKAR]

Dear AlphaFrog,
This is the formula (subtotal) I wanted.
Thanking you.