Announcement

Collapse
No announcement yet.

Max function + Partial criteria

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Max function + Partial criteria



    Hi

    Let me see if I can explain what I'm trying to achieve here.

    I'm trying to find the max value in column C based on several criteria. But the max value should repeated in those rows, where the criteria are met.
    Column A, B, C is how the data is shown in my file. The other column is only for explanatory purpose.

    In range A2:A5 the criteria is the same, however the values are different in column C. The max value in range C2:C5 is 100519, and should therefore be repeated in A2:A5.

    Column F is the output/result.

    Click image for larger version

Name:	excel max example.png
Views:	1
Size:	101.5 KB
ID:	1219304




  • #2
    Hi,

    Sadly ... an image is an inert object ...

    Why don't you attach your worksheet with your next message ...

    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment


    • #3
      I have attached my example

      Book2.xlsx

      Comment


      • #4


        Hi,

        Thanks for the file ...

        Are you sure about the Max value you are showing ...?

        See your test file ...

        Hope this will help
        Attached Files
        If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

        Comment

        Working...
        X