You see, my main purpose would be to find the max/min within a range, and return

Question

You see, my main purpose would be to find the max/min within a range, and return the value as well as the associated date. I thought my formula was working fine, until I discovered that it's been ignoring the maximum value situated in the first of a series.

Here is what I'm saying:

                                                                                                                              Col.       C                                          D                                               E

The value its returning is 211.78, and not the true maximum of 271.86. But when the MAX is used as a stand-alone formula, it would rightly return 271.56.

Well, it seems to be just ignoring these first 2 columns because I'm already in column GS and I've been getting the right maximum values.

Any help will be greatly appreciated.

Thanks in advance.

Row # 1 NAVPU                271.56                 220.00                 211.78 Row # 2 22-May-13 25-Jun-13 28-Aug-13 Row #3 Wed Tue Wed

Explanation / Answer

Try this

=HLOOKUP(MAX($C$2:$E$2),$C$2:$E$2,1,0)

Hope this helps.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.