Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 04-07-2021, 07:04 PM
Dave T Dave T is offline Assign text string against groups of data Windows 7 64bit Assign text string against groups of data Office 2013
Advanced Beginner
Assign text string against groups of data
 
Join Date: Nov 2014
Location: Australia
Posts: 66
Dave T is on a distinguished road
Default

Hello p45cal,

Minor edit where I changed your use of the semi-colons to commas.

I can live with the results of your formula, but just out of curiosity can you add more criteria and if so how do you do it ???

For example I have been trying to add the following:
"RESTRICTION","OK [Ru]","OK [Vu]","Analysed","Overloaded [Vu]"
without success.

I usually filter out everything above and only retain 'OVERLOADED', '5 kph centre' & '10 kph', but I was curious how they could be added.

Having said that it might just be easier to just return a blank if the column group does not contain any of the the three criteria I am after.

Regards, Dave T
Reply With Quote
 



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
Assign text string against groups of data Sorting Groups of Data, keeping continuity carter Excel 1 04-06-2015 01:25 AM
Assign text string against groups of data 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 text string against groups of data 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 01:24 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