View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pash Pash is offline
external usenet poster
 
Posts: 3
Default Drag and fill on a filtered data sheet.

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.