Find Minimum and Maximum Seat Numbers by Group in Excel
Question details
Find the lowest and highest seat numbers for each combination of city, building, floor, and wing.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains seat records that need to be summarized by location.
- Observed behavior
- Each location group should show its minimum and maximum seat numbers.
Make sure each column has a header, including City, Building, Floor, Wing, and Seat Number. Check that seat numbers are stored as numbers so the PivotTable can calculate Min and Max.
Use an Excel PivotTable to summarize seat ranges
Create a grouped summary with a minimum and maximum seat number for each location.
Select a cell in the source data, then choose Insert > PivotTable. Confirm the data range, select a destination, and click OK.
In the PivotTable Fields pane, drag City, Building, Floor, and Wing into the Rows area in that order.
Drag Seat Number into the Values area twice. The PivotTable will create two separate value fields.
Open the first Seat Number field's menu in Values, choose Value Field Settings, and select Min. Repeat for the second field, selecting Max.
In Value Field Settings, set the Min field's Custom Name to SeatRange_From and the Max field's Custom Name to SeatRange_To.

Find grouped seat ranges with WPS Spreadsheet
Use a PivotTable in WPS Spreadsheet to group location fields and calculate the minimum and maximum seat numbers for each group.
- 1. Open the seat records: Open the workbook in WPS Spreadsheet and select a cell in the data range.
- 2. Create a PivotTable: Choose Insert > PivotTable, confirm the source range and destination, and click OK.
- 3. Arrange the fields: Drag City, Building, Floor, and Wing into Rows, then drag Seat Number into Values twice.
- 4. Set the calculations: Open Value Field Settings for each Seat Number field. Select Min for the first and Max for the second, then rename them SeatRange_From and SeatRange_To.

Frequently Asked Questions
Why does my PivotTable count seat numbers instead of showing the minimum?
Excel may treat the Seat Number column as text. Convert the source values to numbers, right-click the PivotTable and select Refresh, then use Value Field Settings to select Min or Max.
How do I update the seat ranges after changing the source data?
Right-click the PivotTable and select Refresh. If new rows fall outside the original source range, select the PivotTable and use PivotTable Analyze > Change Data Source to update the range.
Can I show the location fields in separate columns?
Yes. Select the PivotTable and choose Design > Report Layout > Show in Tabular Form. You can also choose Repeat All Item Labels from the same menu.
Do the minimum and maximum prove that every seat number between them exists?
No. Min and Max show only the endpoints; the group may have gaps or duplicate seat numbers. Check the underlying records if you need to verify continuity.




