![]() |
#1
|
|||
|
|||
![]()
1. All the “Y” values need to be converted into numbers in the “summary” sheet. So for example Keyword building team creates events=1, NO Level 1 examples=2, Ready for Business Review=3, Business Review=4, Legal Review=5, and Production=6
*this requirement is not mandatory, requirement 2 is most important. 2. In the Ranking Summary Sheet I have added a “Status” Column that will denote what status each event is in. If one of the events is equal to a 6 then it will say RELEASE. If it is not a 6, then it will denote what number or status it is in from the “Summary” sheet. |
#2
|
||||
|
||||
![]()
Why do you want "y" when you want a number?
For example in H4 instead of =IF(Details!M8=0,"", "Y") enter =IF(Details!M8=0, "", 2) and the same for the other columns
__________________
Using O365 v2503 - 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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
AHB | Excel | 2 | 08-11-2012 08:50 AM |
![]() |
Shane.thompson | Excel | 1 | 06-28-2012 06:07 PM |
Match two sets of data and display specific data | lolly150 | Excel | 1 | 05-14-2012 10:33 PM |
![]() |
cjaye | Excel Programming | 11 | 05-08-2012 04:22 PM |
![]() |
TonyMan | PowerPoint | 1 | 04-14-2010 05:45 AM |