Making a list of names that have the same value

You might consider taking advantage of the powerful functionality built into Numbers. No formulas!

One easy way is filters, which leaves the data in place in your original table. Leaving the data in place is usually more efficient.

But if you need the filtered subset of your data in a separate table then you can use a Pivot Table.

Click in the table with your data and from the menu choose Organize > Create > Pivot Table > On Current Sheet.

Drag the Value from the Fields box down to the Rows box. Then again drag it, this time from the Fields box down into the Values box.

Control click in the cell in column B and choose Create Table for Source data.

The resulting table is this, which you can rename, copy into another document, etc.

(To copy a table, click in it, then click the concentric rings "bull-eye" to its upper left, command-c to copy, click on the canvas of the sheet where you want to place it, and command-v to paste.)

Now that you have the subset of the data in a separate table, you can delete the Pivot Table. To do that, click in it, then click the gridded symbol to its upper left, and hit delete.

All this takes a few seconds at most.

SG

Two other simple solutions, if the 'corresponding values' are listed in a separate column is to Sort the table ascending on the values in that column,

OR

to use Categories, and set the categories to use the values in that column.

Either of thes will sort group the entries using ;the values in the 'corresponding values' column.

Regards,

Barry

The easy solution is a filter

But if you really want an additional table with only 0 you could do this

Create an additional column that will count rows with 0, all other rows will be empty

In your second table you can use XLOOKUP.

Let me know if this was helpful

Ralf