Assign text string against groups of data

Dave T · #11 04-11-2021, 05:28 PM

Hello p45cal,

Wow, a very impressive modification.

I have been changing your formula by switching parts around and editing the expected result.

In my attached workbook I used data validation in column B to quickly change the restriction type to test the formula.
The small table to the right are the restrictions in order of severity and the expected result from the formula.

As I said in a previous post, I was quite happy with your original formula and it would have done what I was after, but this modification has taken it to another level.

Greatly appreciated, Dave T

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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