Post # 1
I have over 1200 hours that are coded. The codes are numbers 1-7.
So for example, I have something that looks like this:
Is there anyway I can group them (like all 7s together, all 3s together) without them losing the hours that are attached?
Post # 3
@sunkissed19: Click the little arrow in the upper left corner. That should select everything.
Then click sort and filter, right hand side at the top
Custom sort, uncheck my data has headers, and sort by column A
Post # 4
Highlight the header cell go to data >filter. Then click on the icon in the top right of te cell and sort smallest to largest
Post # 5
- Wedding: March 2014 - Brazil Room
So to create a “database” for sorting, you can do it like this. Highlight the data you want including the titles. In the “name box” on the left (where it usually shows the cell number (A1, C24, etc) type in any name you want and then press enter. Now whenever you click the dropdown for that box, your database will be listed.
Then right-click in the column you want to sort and go to “sort” as pictured. Hope that helps 🙂
Post # 6
thank you all! you just intervened on a fight between Fiance and I because it was going to take all night to do it ourselves.
you’re the best!!
@NovaGrey: Thank you so much for the images! big big help!