G
Gotroots
The following formula works fine however it returns #NUM! when there are no
more records to display. I do not want the error to return.
=INDEX(INDIRECT("$a$1:$a$500"),MATCH(SMALL($C$1:$C$500,ROWS($IV$1:IV1)),$C$1:$C$500,0))
more records to display. I do not want the error to return.
=INDEX(INDIRECT("$a$1:$a$500"),MATCH(SMALL($C$1:$C$500,ROWS($IV$1:IV1)),$C$1:$C$500,0))