C
caj
This
=INDEX(Sheet1!$A$1:$CT$400,SMALL(IF(Sheet1!$K$1:$K$400<.98,ROW(Sheet1!$A$1:$CT$400)),ROW(Sheet1!1:1)),1)
Does what i need it do, EXCEPT it lists all the results that have 0 so I end
up with a sheet2 that looks like:
Name percent
Jones .95
0 0
0 0
smith .96
How do I get it to stop showing the results that equal 0?
=INDEX(Sheet1!$A$1:$CT$400,SMALL(IF(Sheet1!$K$1:$K$400<.98,ROW(Sheet1!$A$1:$CT$400)),ROW(Sheet1!1:1)),1)
Does what i need it do, EXCEPT it lists all the results that have 0 so I end
up with a sheet2 that looks like:
Name percent
Jones .95
0 0
0 0
smith .96
How do I get it to stop showing the results that equal 0?