how to get the min and max on multiple columns by grouping

Copper Contributor
 
city building floor wing seatno
blregla5FA1
blregla5FA2
blregla5FA5
blregla5FB6
blregla5FB7
blregla5FB11
blregla5FB12
blregla5FB13
blregla5F 234
blregla5F 254

in Excel, want to get the min and max result as below

city building floor wing seatrange_From seatrange_To
blregla5FA12
blregla5FA55
blregla5FB67
blregla5FB1113
blregla5F 234234
blregla5F 254254

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.

@Jan Karel Pieterseit 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 :)