Assign text string against groups of data

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

#14

04-12-2021, 05:50 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

It's maybe late now, but in case you can upgrade to Excel365 or Excel2019, this task will be much easier - like:

Code:

=IF(COUNTIFS($A$3:$A$153,$A3,$F$3:$F$153,"OVERLOADED")>0;"OVERLOADED";MINIFS($F$3:$F$153,$A$3:$A$153,$A3))

And when you'll use e.g. value 0 instead of "OVERLADED", it simplifies again!

Code:

=MINIFS($F$3:$F$153,$A$3:$A$153,$A3)

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 07:26 AM.