Assign text string against groups of data

		Microsoft Office Forums > Microsoft Excel > Excel
Assign text string against groups of data

04-07-2021, 10:49 AM

p45cal

Windows 10 Assign text string against groups of data

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search for specific data in a text string	teligence	Excel	1	05-20-2017 11:51 AM
How to get groups of data on each page	aldumil	Mail Merge	7	06-24-2015 01:28 PM
Sorting Groups of Data, keeping continuity	carter	Excel	1	04-06-2015 01:25 AM
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Assign resource groups to tasks	jjmclell	Project	2	12-17-2012 04:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 PM.