Extract unique values based on criteria

[NeverSayDie]

Hello everybody, my 1st post.
I have checked for similiar posts here but not quite what I need.
I need assistance with a formula to return all unique values pertaining to just one criteria from an ever expanding data base. It is to be non VBA and not using filters. The data is Horse Racing results entered on a sheet called 'Race Resuts'.
On that sheet I have named ranges:- 'TRK' = Col 'C' and 'DIST' = Col 'G'
On sheet 'TRACK DETAILS' in $B$5 I enter the Track Name and then from $A$8:$A$37 I want the ALL the Unique distances related to that track to be inputed. I have a helper Col $I$8:$I$37 with numbers 1 to 30 for the formula I tried [that doesn't bring unique values but all repeated values as well].

I tried this failed formula:-
{=IF(ISERROR(LARGE(IF(TRK,=$B$5,DIST),"",LARGE(IF(TRK=$B$5,DIST),$I8))} .... copied down. My guess is that I may have to use ROW ... but I have tried and failed because it is beyond my capability.

Thanks for any help.

 

[NeverSayDie]

My Helper $I$6:$I$37
▼ New Helper $J$6:$J$37
1 Blanks
2 ""
3 ""
4 ""
5 ""
6 1200
7 1523
8 1600
9 3000
10 1200
11 1523
12 2040
13 1000
14
15
16

Results from formula
$A$6:$A$37
1200 ◄$A$6 ▼
1523
1600
3000
2040
1000
Starts from $A$6 and blanks underneath the 1000

Hope that makes sense.

 

[GlennUK]

er... so that's the results you asked for. There are the unique values in $A$6 downwards.

 

[NeverSayDie]

Not quite Glenn. As stated previously it strangely left seven other unique distances behind. It pulled six of them. ??? Your getting SOOOooo close.

Les.

 

[GlennUK]

So, are the values in the helper column all the ones you'd expect for the chosen course? 'Cos the uniques you're showing are the uniques from the helper column you've shown.

 

[NeverSayDie]

No it doesn't Glenn. Col $J6:$J37 shows 8 distances only [instead of 13], 6 only of them unique of the 13 unique values from that particular Track Data. Col $A6:$A37 then displays the unique values correctly from that Column ... most of the time, and somtimes it goes screwy and does what my original failed effort did and try and show ALL of the distances that start with the 1st unique one from Col J and produces a column of 1200's... Weird. I haven't done anything to any of the original formulas. They are exactly as the other day.

Les.

 

[GlennUK]

I'll send you a private message.