Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using fill handle on filtered data | New Users to Excel | |||
Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
Updated filtered data on next sheet | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
Does Excel support Auto fill on filtered data? | Excel Discussion (Misc queries) |