Drag and fill on a filtered data sheet.

P

Pash

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.
 
P

Pash

Dear Muddan Madhu,
Thank you very much for your help, but I still can't get how to give the
needed range. Let me explain once more what I need, I guess I wasn't clear
first time.

(filtered mode)
Row No. Price 3rd column
1 100$ ?
10 260$
40 300$
55 40$
120 170$

So we have already filtered sheet here, and I need to place a formula in the
third column (instead "?") which will find the minimum value for Rows from 1
to 10, including filtered (hidden) rows. If I specify the range manually, I
will not be able to drag and fill the formula so as to find out the minimum
value for Rows from 10 to 40, from 40 to 55 etc., as the step is different
(i. e. there is a different number of hidden rows between visible rows). I'm
not sure I could make myself clear enough this time, but in any case, thank
you very much for your help.
 
M

muddan madhu

try this

for Row 1 to 40 =Small(B1:B40,1) or Min(B1:B40)

for Row 41 to 55 =Small(B41:B55,1)........
 
P

Pash

Dear Ashish Mathur,
The column shown in the example is not the one to which filtering is
applied. I've filtered the sheet by one column, but need the minimum values
to be calculated for another one.

Best wishes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing cell content on n auto-filtered column 4
Subtotal: Min / Max Offset on Filtered Visible Cells? 4
Count Displayed Rows of a Filtered Worksheet 2
SUMPRODUCT on filtered rows 6
Complicated VBA? Moving filtered data.... 2
Get a row number of range where a value is between minimum and max 2
Creating a numbered list on a filtered worksheet 12
some numbers to be blank 1

Top