Hello,
I am trying to do the following.
On one sheet, I have A to AA columns that are capturing the data that I need.
I would like to do the following on separate sheet if possible.
On the sheet Project-Portfolio:
Capture:
Column D7-D312 Project Type (Funded Project, Un-Funded Project, Pilot Program, Production Program (Four categories))
Column E7-E312 Project Name (various)
Column AA7-AA312 Project Score
Project Type - Project Name - Project Score (Highest to lowest top 10)
Funded Project David 400
Funded Project David 2 355
Funded Project David 3 354
Etc
Second set same headers:
Un-Funded Project John 1 322
Un-Funded Project Jonh 2 320
Etc
Is this possible to do within Excel? I am assuming it is, but if you have looked at some of my older posts, I am still pretty new at this.
Thanks
Bookmarks