Maximum currency

[EinarOSies]

Please I need help in finding the maximum value in a range.

In column J are a combination of strings and formulas. I attached an info column K to aid in understanding my problem and formula in column J.
How can I input a formula to get the largest or maximum value in column J?

 

[Peter_SSs]

=AGGREGATE(14,6,MID(J4:J15,5,20)/((MID(J4:J15,5,20)+0>=1)*(MID(J4:J15,5,20)+0<=40)),1)

=AGGREGATE(15,6,MID(J4:J15,5,20)/((MID(J4:J15,5,20)+0>=1)*(MID(J4:J15,5,20)+0<=40)),1)

=AVERAGE(IF(MID(J4:J15,5,20)+0>=1,IF(MID(J4:J15,5,20)+0<=40,MID(J4:J15,5,20)+0,""),""))

 

[EinarOSies]

Please thanks Peter for the constant help.

 

[Peter_SSs]

You're welcome.

 

[EinarOSies]

Please Peter so how can I make an index-match function on both of column B and A that's the date and day

 

[Peter_SSs]

That is a very different question so you should start a new thread for that (& don't forget about XL2BB )

 

[EinarOSies]

Please okay