Forum Discussion
how to get the min and max on multiple columns by grouping
city building floor wing seatno
| blr | egla | 5F | A | 1 |
| blr | egla | 5F | A | 2 |
| blr | egla | 5F | A | 5 |
| blr | egla | 5F | B | 6 |
| blr | egla | 5F | B | 7 |
| blr | egla | 5F | B | 11 |
| blr | egla | 5F | B | 12 |
| blr | egla | 5F | B | 13 |
| blr | egla | 5F | 234 | |
| blr | egla | 5F | 254 |
in Excel, want to get the min and max result as below
city building floor wing seatrange_From seatrange_To
| blr | egla | 5F | A | 1 | 2 |
| blr | egla | 5F | A | 5 | 5 |
| blr | egla | 5F | B | 6 | 7 |
| blr | egla | 5F | B | 11 | 13 |
| blr | egla | 5F | 234 | 234 | |
| blr | egla | 5F | 254 | 254 |
how to do it in excel summarize like above
3 Replies
- Create a pivot table where you drag city, building and floor to the row area. Then drag seat no to the sigma area twice. In the pivot table, rightclick the first seatno column and choose Display values as, Min. Repeat for the second, choose Max.
JKPieterseit works for continues seat no. not for the discreet seat numbers
- Right, I was spotted the Min and Max in your table and just assumed that was the calculation needed 🙂
