Index problem

[MRozell]

When I use =SMALL($B$21:$U$21,1) or =LARGE($B$21:$U$21,1) and do it for 1,2,3, and 4 I will get the amount of the smallest and largest.

I am having trouble when I use =INDEX($B$20:$U$20,MATCH(B26,$B$21:$U$21,0))

When I looked at the small or large and there is more than 1 of the same value it just input both of them

Than when I try to index it, it only gives me the first one how ever many time that value repeats

I need to know all the numbers have the same value

[tamthat]

Please Login or Register  to view this content.

[Glenn Kennedy]

A simpler formula, copied across (B25)

=AGGREGATE(15,6,$B$20:$U$20/($B$21:$U$21=B$26),COUNTIF($B$26:B26,B26))

and for that matter, also in C25, copied across:
=SMALL($B$21:$U$21,COLUMNS($B:B))