Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2022, 06:32 AM
IamThatGuy IamThatGuy is offline Working out RAG status based on 3 columns Mac OS X Working out RAG status based on 3 columns Office 2021
Novice
Working out RAG status based on 3 columns
 
Join Date: Feb 2022
Posts: 14
IamThatGuy is on a distinguished road
Default Working out RAG status based on 3 columns

Trying to summarise the RAG status in one field but unsure how I do that

Column D needs to make sure it groups Column A and then column B and then assign the lowest RAG from column C

For example, For Workstream 1, 'Pilot' appears twice in column B with the lowest RAG status of Red. So Column D automatically needs to assign Red to Workstream 1, pilot sub workstream.

If it is easier then RAG status could be assigned a number too. For example: Red becomes 1, Amber = 2, Green = 3, Complete = 4 etc



Table with dummy data below. Grateful for any assistance on this, please.
Attached Files
File Type: xlsx RAG Test.xlsx (9.4 KB, 5 views)
Reply With Quote
  #2  
Old 02-15-2022, 07:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Working out RAG status based on 3 columns Windows 7 64bit Working out RAG status based on 3 columns Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

What does "RAG" mean please?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 02-15-2022, 07:48 AM
IamThatGuy IamThatGuy is offline Working out RAG status based on 3 columns Mac OS X Working out RAG status based on 3 columns Office 2021
Novice
Working out RAG status based on 3 columns
 
Join Date: Feb 2022
Posts: 14
IamThatGuy is on a distinguished road
Default

Solution here: Working out RAG status based on 3 columns | MrExcel Message Board
Reply With Quote
  #4  
Old 02-15-2022, 03:53 PM
kilroyscarnival kilroyscarnival is offline Working out RAG status based on 3 columns Windows 10 Working out RAG status based on 3 columns Office 2019
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by Pecoflyer View Post
What does "RAG" mean please?
I had to look it up. It stands for Red-Amber-Green, the traffic-light color coding system that is used in a lot of planning and CRM setups. Red generally meaning it's a hot potato or high priority, etc.
Reply With Quote
Reply

Tags
rag, rag rating, rag status

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to automate Roster file refreshes based on a status value Tphil413 Excel Programming 4 08-02-2019 07:43 AM
Show/Delete paragraph based on checkbox status mahaabub Word VBA 1 05-13-2019 05:33 PM
Late status based on end date gerhardstru Project 0 08-03-2018 01:09 AM
Working out RAG status based on 3 columns Hide/Show text based upon check box status nathan.gray@emerson.com Word VBA 5 12-08-2017 01:08 PM
Working out RAG status based on 3 columns Checking ref # status based on sheet2 ref #. aligahk06 Excel 1 04-26-2010 11:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft