Hi, i have two columns of data e.g
A B
1 5
3 4
2 3
3 5
What i need to do is match cloumn B highest number (5), with the highest number in column A, this should be (3) but i dont know how to do this. any help would be most welcome
Hi, i have two columns of data e.g
A B
1 5
3 4
2 3
3 5
What i need to do is match cloumn B highest number (5), with the highest number in column A, this should be (3) but i dont know how to do this. any help would be most welcome
Hi
I guess you have the 1 in A1 cell and 5 in B1 cell and so on...then if you put =MAX(A1:A4) in the A6 cell and =MAX(B1:B4) in the B6 cell it wil find the highest numers in the colums
hope this will get you going
You can use this array formula
=MAX(IF(B1:B4=MAX(B1:B4),A1:A4))
confirmed with Ctrl+Shift+Enter (instead of just Enter)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks