########?

[bill gras]

please help

I have a array formula as follows
=INDEX(st5!$C$1:$C$1800,SMALL(IF(st5!$A$1:$A$1800=D4,ROW
(st5!$A$1:$A$1800)),ROW(st5!$1:$1)))
when there is no value in the cell it returns ##### is
there a way that this can be fixed so a blank cell can be
seen?
thanking you all!
.
sory frank your formula did not work

can you please try again
thank you
..

 

[Harlan Grove]

please help

sory frank your formula did not work
can you please try again

Frank's suggestion works as long as you fill in the blanks (or elipses). How
did it not work?

Reformatting your formula

=INDEX(st5!$C$1:$C$1800,SMALL(IF(st5!$A$1:$A$1800=D4,
ROW(st5!$A$1:$A$1800)),ROW(st5!$1:$1)))

If you're trying to mask only blanks values, try the array formula

=IF(COUNT(IF(st5!$A$1:$A$1800=D4,st5!$C$1:$C$1800))>=ROW(st5!$1:$1),
INDEX(st5!$C$1:$C$1800,SMALL(IF(st5!$A$1:$A$1800=D4,
ROW(st5!$A$1:$A$1800)),ROW(st5!$1:$1))),"")

 

[bill gras]

-----Original Message-----
please help

=IF(ISERROR(INDEX(...)),"",INDEX(...)) (sorry i left your
formula out)

 

[Frank Kabel]

Hi
as Harlan said you have to fill in your formula for INDEX(...)