SOLVED

#NUM! help please

New Contributor

Hi Everyone! How can i fix #NUM! in Excel 2016.

 

I am using= IF(ISERROR(SMALL(V:V,ROWS($J$13))),"",INDEX(J:J,MATCH(SMALL(V:V,ROWS($J$13:J30)),V:V,0))). I would like the cell to just be blank, rather than the #NUM! Can you please help.

 

Thank you in advance!

2 Replies
best response confirmed by Us2022 (New Contributor)
Solution

@Us2022 Not really sure your you are trying to achieve here, but perhaps like this:

=IFERROR(INDEX(J:J,MATCH(SMALL(V:V,ROWS($J$13:J30)),V:V,0)),"")
I listed items and left blank rows between the items. I wanted to use a formula to clear the blanks by having the items automatically shift up. Thank you so much!!! That worked perfectly!