Home

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
Kimberlyl2040
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
Related Conversations
Need help with =IFerror function
Leon_Redclifft in Excel on
0 Replies
Notification
Rune91 in Excel on
0 Replies
Unable to open my exel worksheet
chrisngundu in Excel on
3 Replies
Weekly rotating list
Rashy_wearer2 in Excel on
1 Replies
Formula to calculate between "Closing Balances"
calof1 in Excel on
2 Replies
Userform-Transferred Data must not be editable
Mr_Buttons in Excel on
0 Replies