I am trying to retrieve the output of the largest number in column B given a certain date in column A?

In my example, Dec 1st should output 3 as the max, Dec 2nd should output 2 as the max, Dec 3rd should output 4 as the max, Dec 4 should output 0 as the max, Dec 5th should output 1 as the max. Can you please show me the formulas that should go in F3:F7 to achieve these values?

Attachment image

2 Answers

Relevance
  • Alan
    Lv 7
    2 months ago
    Favorite Answer

    See image. Y/A first put ran lines together then hid the answer 

    when I fixed it. 

    Attachment image
    • Joe2 months agoReport

      This formula fixes my problem. Thank you so much for your help!

    • Login to reply the answers
  • Lv 7
    2 months ago

    in what program? we aren't psychic...

    • Joe2 months agoReport

      Microsoft Excel 2016

    • Login to reply the answers
Still have questions? Get your answers by asking now.