Highest / Lowest Value & Text Match + Streak

Hi guys, may I ask for your suggestion on how to work around this case?

A file is attached, and also a screenshot. Formulas would need to be created where text is in red. I left all cells, rows, tabs etc as per original file, to keep it consistent.

What would be a workaround this, please? Thanking in advance.

https://www.excelforum.com/attachmen...1&d=1512404316 [EXCEL]

2017-12-04_1808.png

Hi Vill,

Here is the first half of your answer. I'm not sure how to do the streak but the top use an Index Match of Large and Small 1 and 2. See the attached.

Index Match Large and Small.xlsx

If you use the full month name on the second sheet, they will appear as a full name.

Or

If you have real date values on the second sheet and set the format of those dates as MMM on the second sheet and as MMMM on the first sheet it would do what you request. The problem is that the second sheet "Jan", "Feb" ... are text strings, not real date values.

Sure. Using the formula from post #2,

D32 =TEXT((INDEX(Data!D$100:O$100,MATCH(G32,Data!D$101:O$101,0))&1)+0,"mmmm")

Although I'm not sure if this will work with UK regional settings.

Edit: You might have to do "1&..." instead of "...&1". Thanks for the rep!