copy all rows with a certain value in one of the columns

[emmerdales]

Hi,

I run my companies sales tracker on Excel, and I am trying to populate a list of people with zero sales for the week etc.

employee	target	actual	vstgt
ben	2	0	0%
julie	3	1	33%
sarah	2	0	0%

<tbody>
</tbody>

and it auto fill a section of zero sellers, so populate a list of names with a 0% in the vstgt column.

so I want:

Zero Sellers

Ben

Sarah

and auto add more here as the figures change

<tbody>
</tbody>

I will try and upload a sample file.

If anyone would be able to assist I would be very grateful.

thanks

 

[jarjarbingie]

Hi,

I run my companies sales tracker on Excel, and I am trying to populate a list of people with zero sales for the week etc.

employee	target	actual	vstgt
ben	2	0	0%
julie	3	1	33%
sarah	2	0	0%

<tbody>
</tbody>

and it auto fill a section of zero sellers, so populate a list of names with a 0% in the vstgt column.

so I want:

Zero Sellers

Ben

Sarah

and auto add more here as the figures change

<tbody>
</tbody>

I will try and upload a sample file.

If anyone would be able to assist I would be very grateful.

thanks

assuming table1 is in Sheet1 and table2 is in Sheet2:

A2 = IFERROR(INDEX(Sheet1!$A$2:$A$100,SMALL(IF(Sheet1!$D$2:$D$100=0,ROW(Sheet1!$D$2:$D$100),""),ROW()-1)-1),"") press CTRL+SHIFT+ENTER