EinarOSies
Board Regular
- Joined
- Feb 15, 2021
- Messages
- 61
- Office Version
- 2019
- Platform
- Windows
Please can I get an Index-Match formula to find the corresponding day and date in this image for the average,maximum and minimum values in column J
The maximum formula is
The minimum formula is
And the average formula is
Please I just want an Index-Match to know its corresponding days and dates.
Below is the sample file I am working on
Work file
The maximum formula is
Excel Formula:
="GH₵ "&TEXT(AGGREGATE(14,6,MID(J4:J108,5,20)/((MID(J4:J108,5,20)+0>=1)*(MID(J4:J108,5,20)+0<=40)),1),"###.00")
The minimum formula is
Excel Formula:
="GH₵ "&TEXT(AGGREGATE(15,6,MID(J4:J108,5,20)/((MID(J4:J108,5,20)+0>=1)*(MID(J4:J108,5,20)+0<=40)),1),"###.00")
And the average formula is
Excel Formula:
="GH₵ "&TEXT(AVERAGE(IF(MID(J4:J108,5,20)+0>=1,IF(MID(J4:J108,5,20)+0<=40,MID(J4:J108,5,20)+0,""),"")),"###.00")
Please I just want an Index-Match to know its corresponding days and dates.
Below is the sample file I am working on
Work file
Last edited: