Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-23-2021, 05:12 AM
ArviLaanemets ArviLaanemets is offline corresponding row values for max value in a column Windows 8 corresponding row values for max value in a column Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

You can in case the max value in column A is unique. When not, then you need some additional condition to determine, which row with e.g. 157 in column A must be returned!

When all values in column A are unique, then one possible solution:
=INDEX($B$1:$B$300,MATCH(MAX($A$1:$A$300),$A$1:$A$ 300,0)) to return matching entry in column B. When the max value is not unique, the data from 1st row having max value in column A is returned;
In case entry in e.g. column B is always numeric, another option will be also available:
=SUMIFS($B$1:$B$300,$A$1:$A$300,MAX($A$1:$A$300)) When the max value is not unique, the sum of matching values in column B is returned.
Reply With Quote
 



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
corresponding row values for max value in a column 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
corresponding row values for max value in a column Auto-create row from column values ReviTULize Excel 1 03-28-2013 02:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft