What is the logic you have applied for filtering I.e. what is the filtering
criteria
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Pash" wrote in message
...
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.