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]
2
[/td][td]A2
[/td]
[TD="align: right"]68[/TD]
1
A1
[TD="align: right"]90[/TD]
1
A1
[TD="align: right"]65
[/TD]
1
[/td][td]B0
[/td]
[TD="align: right"]100[/TD]
2
[/td][td]B5
[/td]
[TD="align: right"]72[/TD]
2
[/td][td]A1
[/td]
[TD="align: right"]78[/TD]
1
[/td][td]A2
[/td]
[TD="align: right"]68[/TD]
1
A1
[/td]
[TD="align: right"]128[/TD]
[/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.