Table, and Array function help

[dsm63]

Hey Guys,

First of all i wanna say thank you for the last time i was helped out by this forum.

I am looking for a little help with indexing in tables.

I have 2 tables one is going to be a database. and i want to use the other to recall all the data that matches to an athletes name.

for convenience i have put them both on the same page.

my question is this. when i index that data on the second table there if there is no data i get a "0" i would like it to just say blank.

also my formula to index the data is

{=IFERROR(INDEX(Athletes[Date], SMALL(IF(Athletes[Athletes Name]=$N$1,ROW(Athletes[Athletes Name])-3),ROWS(N$4:N4))),"-")}

i had another program that did something very similar that used -1 i am not sure why this one would only work with -3

forum file.xlsx


thank you in advance.

[RobertMika]

use Custom Format:
0;-0;;@

[dsm63]

That Worked Pretty Darn Well!!

[martindwilson]

the reason for the -3 is
{=IFERROR(INDEX(Athletes[Date], SMALL(IF(Athletes[Athletes Name]=$N$1,ROW(Athletes[Athletes Name])-3),ROWS(N$4:N4))),"-")}
ROW(Athletes[Athletes Name]) resolves to row(b4:b12) which in turn represents a range {4;5;6;7;8;9;10;11;12} ie each row number of the range
but for the small(if to work it needs to start at 1 {1,2,3,4,5,6,7,8,9}
so row(b4:b12)-3 does the equivelent of {4-3;5-3;6-3;7-3;8-3;9-3;10-3;11-3;12-3} giving the {1,2,3,4,5,6,7,8,9} required

[dsm63]

problem solved i suppose!! thanks everyone