|
|
#1
11-22-2021, 07:49 PM
|
|||
|
|||
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?
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Return as many Y as the number of occurrence of values in another column | Marcia | Excel | 2 | 11-27-2020 04:19 PM |
| Formula to check combinations of values in one column to find match from another column | kong1802 | Excel | 1 | 06-15-2018 05:26 AM |
 SumIfs not able to get two values from the same column..
|
LearnerExcel | Excel | 1 | 01-04-2017 02:32 PM |
| copy non zero values to new column | Guloluseus | Excel | 3 | 01-10-2016 08:48 AM |
|
Auto-create row from column values
|
ReviTULize | Excel | 1 | 03-28-2013 02:27 AM |
Windows 7 64bit 
Office 2013
Threaded Mode