Forum Discussion
Method by which to apply multiple values to a single category for sorting purposes?
Hello all! I have a pretty basic knowledge of excel functions, and am trying to set up a spreadsheet for the purpose of sorting items in my wardrobe by different qualities (type, appropriate weat...
The truth is you'd be far better served by keeping each category of quality or attribute in its own column. Mixing diverse categories or labels into one column makes for chaos. (There are frequent inquiries here in this forum asking "How do I separate out multiple entries in one cell?!")
For items with multiple colors, unless you're really finicky, I'd think it would suffice to have one column for "Primary color" and a second for "Secondary". But all other qualities or dimensions should be on their own. I'm thinking of columns things like
- Item Name or Description
- Brand (if this matters)
- Season
- Size
- Fabric
- Primary Color
- Secondary Color
- Etc
You could also add columns for such things as
- Gift from
- Price
- Date purchased