ExcelBanter - MINIMUM SEARCH IN THE NEXT 15 ENTRIES

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MINIMUM SEARCH IN THE NEXT 15 ENTRIES (https://www.excelbanter.com/excel-discussion-misc-queries/263728-minimum-search-next-15-entries.html)

Bruno

MINIMUM SEARCH IN THE NEXT 15 ENTRIES

I have a table with 2 by n entries.
On the 1st column I have continuous values on the 2nd they're random.
I want to search the minimum value on the 15 entries on the left after each
entry on the righ.
The range can't contain the value on the left to the random entry.

Can anyone help?

Bruno

MINIMUM SEARCH IN THE NEXT 15 ENTRIES

SOLVED

All times are GMT +1. The time now is 04:30 AM.