How to Count Suppliers Once per Date and Group in Excel
Question details
The user needs to display a supplier name only on the first row of each supplier group for a date and keep duplicate supplier rows blank.

- Product
- Excel / WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with a dated supplier list and wants a cleaner grouped view that avoids repeating supplier names for the same date.
- Observed behavior
- Duplicate supplier names for the same date should be hidden so only the first occurrence appears.
Confirm which columns hold the dates and supplier names, and note the first data row. In the example formula, dates are in column B, suppliers are in column C, and the formula starts in D4.
Use a COUNTIFS Formula to Display Each Supplier Once per Date
Use this when you want to suppress repeated supplier names within the same date and keep only the first occurrence visible.
The formula counts date-and-supplier pairs from the start of the data down to the current row. Only the first occurrence returns the supplier label; later duplicates return an empty string.
Click cell D4 or the first cell of the column where you want the grouped supplier label to appear.
Type =IF(COUNTIFS($B$4:$B4,$B4,$C$4:$C4,$C4)=1,"Supplier "&$C4,"") and press Enter.
Drag the fill handle from D4 down through the remaining data rows to apply the grouping logic.

Count and Group Suppliers Once per Date in WPS Office Spreadsheets
Use the same COUNTIFS formula in WPS Office Spreadsheets to display a supplier only on the first row for each date-and-supplier group, leaving duplicate rows blank.
- 1. Download and install WPS Office: Visit the official WPS Office website and download the free version, then install it on your computer.
- 2. Open the dated supplier workbook: Launch WPS Office Spreadsheets and open the workbook that contains the date and supplier columns.
- 3. Select the first formula cell: Click the first cell where the grouped supplier label should appear, such as D4.
- 4. Enter the COUNTIFS formula: Type =IF(COUNTIFS($B$4:$B4,$B4,$C$4:$C4,$C4)=1,"Supplier "&$C4,"") and press Enter.
- 5. Fill the formula down: Drag the fill handle down the column to apply the formula to all supplier rows, then save the file.

Frequently Asked Questions
What does this COUNTIFS formula do?
It counts how many times the current date and supplier combination has appeared from the first data row down to the current row. When the count is 1, it displays 'Supplier ' plus the supplier name; otherwise it returns blank.
What if my columns are not B and C?
Replace $B$4:$B4 and $C$4:$C4 with your actual date and supplier columns, and adjust the formula start cell to match the first row of your data.
Can I use this formula in WPS Office Spreadsheets?
Yes, WPS Office Spreadsheets supports the IF and COUNTIFS functions, so you can enter and fill the same formula in a WPS workbook.
How do I fill the formula down without breaking the range?
Select the formula cell, drag the fill handle downward through the data rows, or double-click the fill handle if adjacent cells contain data.




