Pivot Table Issues

Find Minimum and Maximum Seat Numbers by Group in Excel

Ayan MasoodAyan Masood Nov 18, 2026 869 views

Question details

Find the lowest and highest seat numbers for each combination of city, building, floor, and wing.

Find Minimum and Maximum Seat Numbers by Group in Excel
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.
Before you start

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.

Solution 1Recommended

Use an Excel PivotTable to summarize seat ranges

Create a grouped summary with a minimum and maximum seat number for each location.

1
Insert a PivotTable

Select a cell in the source data, then choose Insert > PivotTable. Confirm the data range, select a destination, and click OK.

2
Add the location fields

In the PivotTable Fields pane, drag City, Building, Floor, and Wing into the Rows area in that order.

3
Add seat numbers twice

Drag Seat Number into the Values area twice. The PivotTable will create two separate value fields.

4
Set the minimum and maximum

Open the first Seat Number field's menu in Values, choose Value Field Settings, and select Min. Repeat for the second field, selecting Max.

5
Rename the results

In Value Field Settings, set the Min field's Custom Name to SeatRange_From and the Max field's Custom Name to SeatRange_To.

Use an Excel PivotTable to summarize seat ranges
Show each group on its own row: For a clearer table, select the PivotTable and choose Design > Report Layout > Show in Tabular Form. Expand the row groups if their details are collapsed.
Summarize seat ranges in WPS

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. 1. Open the seat records: Open the workbook in WPS Spreadsheet and select a cell in the data range.
  2. 2. Create a PivotTable: Choose Insert > PivotTable, confirm the source range and destination, and click OK.
  3. 3. Arrange the fields: Drag City, Building, Floor, and Wing into Rows, then drag Seat Number into Values twice.
  4. 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.
Calculate minimum and maximum seat numbers in one grouped summary.Open and edit Microsoft Excel XLS and XLSX files.Use a familiar spreadsheet interface to organize location data.
microsoft office alternative - wps office

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.