Lowest value in range of data

[slimimi]

Hello there.
I am trying to place a formula in Cell "S5" that will look at sheet "audusd" in the entire Column D and return the Highest value.

Can anyone help plzzz?

​

 

[DonkeyOte]

either of MAX(audusd!d:d) or LARGE(audusd!D:D,1) should work for you

 

[WinteE]

Try this :

=MAX(D:D)

 

[slimimi]

thats great thanks.
But i need the formula to look at a different sheet, say for example, "audusd" in column D. Is that possible?

 

[Richard Schollar]

Did you look at lasw10's answer?

 

[slimimi]

so sorry. thank you guys. thanks lasw10. I was Trying to do too many things at the same time

 

[slimimi]

do you mind if i take that 1 step further. is it possible to add a substitute function into that formula for the sheet name? for example :

look in cell A5 (which will be "AUD/USD"

now (same formula) but instead of looking at sheet "audusd" we look for sheet based on cell value from Cell A5 but substituting the "/" for a "" ?

 

[DonkeyOte]

=max(indirect(substitute(a5,"/","")&"!d:d"))

 

[slimimi]

wow - thanks so much...

 

[Peter_SSs]

I am trying to place a formula ... that will look ... in the entire Column D and return the Highest value.

Interesting question .... given the topic title!