Excel formatting help

%3CLINGO-SUB%20id%3D%22lingo-sub-859831%22%20slang%3D%22en-US%22%3EExcel%20formatting%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-859831%22%20slang%3D%22en-US%22%3EI%20need%20help%20displaying%20Information%20in%20excel.%3CBR%20%2F%3EIf%20I%20have%20a%20start%20date%20and%20end%20date%20column%2C%20project%20type%2C%20outcomes%20of%20project(there%20are%20like%206%20outcomes%20for%20each%20project)%2C%20how%20would%20you%20format%20this%20so%20you%20could%20filter%20by%20outcomes%20to%20see%20the%20most%20common%20outcome%20of%20all%20of%20the%20projects.%3CBR%20%2F%3ESince%20there%20are%20multiple%20outcomes%20listed%20for%20each%20project%2C%20the%20only%20solution%20is%20to%20create%20a%20separate%20line%20for%20each%20outcome%20and%20copy%20and%20paste%20the%20beginning%20information%20into%20each%20line%20and%20then%20filter%20it.%3CBR%20%2F%3EAny%20help%20or%20ideas%20would%20be%20appreciated%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-859831%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor
I need help displaying Information in excel.
If I have a start date and end date column, project type, outcomes of project(there are like 6 outcomes for each project), how would you format this so you could filter by outcomes to see the most common outcome of all of the projects.
Since there are multiple outcomes listed for each project, the only solution is to create a separate line for each outcome and copy and paste the beginning information into each line and then filter it.
Any help or ideas would be appreciated
0 Replies