Hi Guys,
Thanks for having a look at this. I have attached a sample workbook. Could somebody please help me with the following:
1. I have a range of values B2:B17, there are no blanks and no non-numerical data.
2. In the highlighted cells, I would like two formulas that can:
a) count the number of cells in the range (starting from and including cell B2) until the first max. value appears.
b) count the number of cells in the range (starting from and including cell B2) until the first min. value appears.
Looking forward to your answers!
Best regards
Bookmarks