Microsoft Office Forums - View Single Post - corresponding row values for max value in a column

Thread: corresponding row values for max value in a column

View Single Post

Old

11-22-2021, 07:49 PM

marconexcel marconexcel is offline

marconexcel is offline

marconexcel uses Windows 7 64bit

Windows 7 64bit marconexcel uses Office 2013

marconexcel uses Office 2013

Office 2013

Novice

The original poster

Join Date: Feb 2017

Posts: 6

marconexcel is on a distinguished road

Default

corresponding row values for max value in a column

I have three columns of numbers in columns A, B and C with about 300 rows. I can find the max value in A (=max(a1:a300). How do I find the corresponding row entries for columns B and C? For example, if the max value in column A is in row 157, how can I show the values in B157 and C157?

Reply With Quote