INDEX function

  • Thread starter Thread starter caj
  • Start date Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Generate Sorting table(empty cell)?? 1
HELP with INDEX function 1
more re index and match 6
Lookup and count in the same formula 1
INDEX - MATCH - VLOOKUP - returning missing reference 2
cell formula references 2
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
On error from Find, GoTo E 1

Back
Top