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 ...
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 🙂