Thread: [Solved] Assign text string against groups of data
View Single Post
 
Old 04-07-2021, 10:49 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
try in D3, copied down:
Code:
=INDEX({"10 kph";"5 kph centre";"OVERLOADED"},MAX(IF($A$3:$A$153=A3,MATCH($B$3:$B$153,{"10 kph";"5 kph centre";"OVERLOADED"}))))
Depending on your version of Excel you may have to array-enter this formula using Ctrl+Shift+Enter, rather then plain Enter.
Reply With Quote