Maximum in one column according to mutiple conditions

  • Please, some help needed. I'm not into VBA and I can't figure how to find out maximum


    [TABLE="width: 192"]

    [tr]


    [TD="width: 64"]A
    [/TD]
    [TD="width: 64"]B
    [/TD]
    [TD="width: 64, align: right"]C
    [/TD]

    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    A2

    [/td]


    [TD="align: right"]68[/TD]

    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    A1

    [/td]


    [TD="align: right"]90[/TD]

    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    A1

    [/td]


    [TD="align: right"]65
    [/TD]

    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    B0

    [/td]


    [TD="align: right"]100[/TD]

    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    B5

    [/td]


    [TD="align: right"]72[/TD]

    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    A1

    [/td]


    [TD="align: right"]78[/TD]

    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    A2

    [/td]


    [TD="align: right"]68[/TD]

    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    A1

    [/td]


    [TD="align: right"]128[/TD]

    [/tr]


    [/TABLE]


    I need to find out MAX(C) due to conditions on A and B columns. For instance: For "A1" and "1" I need to find out max(90, 65, 128). Same process for "A1" and "2" etc


    Thanks in advance.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!