Drag and fill on a filtered data sheet.
try this
=SUBTOTAL(5,A1:A100)
On Oct 20, 5:44*pm, Pash wrote:
Hi,
I need to find the minimum value among the cells between filtered rows, but
the problem is the range between the filtered rows is different. Here's an
example:
(Already filtered mode)
Row No. * Price *
1 * * * * * * *100$ *
10 * * * * * *260$
40 * * * * * *300$
55 * * * * * *40$
120 * * * * *170$
So I need the minimum price between rows No. 1 and 10 to be displayed on the
first row, and the minimum price between rows No. 10 and 40 to be displayed
on the 10th row etc.
Could anybody help me on this issue?
Thanks in advance.
|