Dear,
Can any one help me by providing formula (index-match-max) or any other combination for the below scenario:
Area A B C D
X 21 24 25 29
Y 13 13 15 16
Z 14 15 17 20
Y 15 17 21 22
X 26 18 23 32
Area X
Section D
Max ??
Need only formula no macros.
Thanks
Bookmarks