excelnoobaugust2017
New Member
- Joined
- Aug 5, 2017
- Messages
- 2
Hi all,
I recently started using Excel and have been trying to solve a problem involve sorting and counting. I'm sure it's been encountered many times before, but am having trouble figuring it out. I tried searching for answers on the forums, but was having trouble putting my question into searches that yielded relevant results, so I thought I'd try posting my own question here.
Essentially I have a spreadsheet like the one below (albeit much longer!):
<tbody>
</tbody>
I'm trying to sort/filter the different people and count the "food" items they bought so that the data can be organized in a spreadsheet similar to the one below.
<tbody>
</tbody>
If anyone has any tips/hints/suggestions for how I should go about approaching the problem, it would be much appreciated!
Thanks for the help!
ExcelNoobAugust2017
I recently started using Excel and have been trying to solve a problem involve sorting and counting. I'm sure it's been encountered many times before, but am having trouble figuring it out. I tried searching for answers on the forums, but was having trouble putting my question into searches that yielded relevant results, so I thought I'd try posting my own question here.
Essentially I have a spreadsheet like the one below (albeit much longer!):
Unique ID | Person | Food Bought |
A | Dylan | Burger |
B | Dylan | Fries |
C | Bill | Burger |
D | Bill | Ice Cream |
E | Simon | Burger |
F | Simon | Burger |
G | Matt | Fries |
<tbody>
</tbody>
I'm trying to sort/filter the different people and count the "food" items they bought so that the data can be organized in a spreadsheet similar to the one below.
Person | Burger | Fries | Ice Cream |
Dylan | 1 | 1 | 0 |
Bill | 1 | 0 | 1 |
Simon | 2 | 0 | 0 |
Matt | 0 | 1 | 0 |
<tbody>
</tbody>
If anyone has any tips/hints/suggestions for how I should go about approaching the problem, it would be much appreciated!
Thanks for the help!
ExcelNoobAugust2017