View Single Post
 
Old 04-07-2021, 07:04 PM
Dave T Dave T is offline Windows 7 64bit Office 2013
Advanced Beginner
 
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