Need Excel Help
Need Excel Help
Hello all,
I have an excel sheet with a list of employees and their preferred shirts, including columns for size, color, gender, and quantity. The issue is that some cells under these columns can contain multiple items (for example, one cell labeled Color may show Black and Blue). How can I adjust it so that it counts each unique combination separately, making ordering simpler? Thank you.
Excel offers various tools that can efficiently handle such needs.
Searchable options are available, yet specific functions may be applied differently based on data specifics and overall layout.
Additionally, "Conditionals" can be utilized for selections, sorting, and counting purposes.
However, the initial step is to share more details about your spreadsheet—such as number of rows, columns, data type, etc.
If necessary, capture a screenshot of a representative part and include it here.
Make sure to remove any personal information.
Also, note what attempts you've made so far and the outcomes observed.
I attempted to generate a pivot table without using employee names, but the output was unsatisfactory due to color cells having multiple values.
I consider building a separate table for each size, color, and gender, then creating a pivot table from that structure, which I am currently exploring.
It seems there might be an opportunity to automate this process, though I’m not sure if a solution exists.