Large() Orders My List, But How Do I Generate Select Values To Form Said List?

[Billy Corman]

See post below. Sorry about that.

[Billy Corman]

Make	Model	Top Speed
Chrysler	Coupe	120
Dodge	4-door	130
Ford	Sedan	123
Chevy	4-door	150
Pontiac	4-door	142
Dodge	Sedan	130
Ford	Electric	133
Chevy	Convertible	153
Pontiac	4x4	142
Dodge	Pick-up	130
BMW	Sedan	160
Audi	Supercar	226
BMW	Supercar	160

In the above (totally fictitious) list/table, I want to determine the 3 fastest "4-door" cars. Right now, I really only know how to determine, and list, the fastest cars. I'd prefer to keep the list unsorted as the info-dump to generate a list will be quite large and repetitive.

The key here is that "sedan", "4-door", and "electric" all qualify.

Sidenote: I've come to these boards twice before and the responses are fast, precise and accurate. I offer thanks to those that have helped in the past.

[Billy Corman]

Basically, I'd like an output as follows:

Chevy	4-door	150
Pontiac	4-door	142
Ford	Electric	133

[JohnTopley]

Try

=INDEX(A$2:A$14,MATCH(LARGE(IF(($B$2:$B$14="4-door")+($B$2:$B$14="Sedan")+($B$2:$B$14="Electric"),$C$2:$C$14),ROWS($1:1)),$C$2:$C$14,0))

Enter with Ctrl+Shift+Enter


Copy across two columns to get Model and Speed and copy down 2 rows

[Billy Corman]

Try

=INDEX(A$2:A$14,MATCH(LARGE(IF(($B$2:$B$14="4-door")+($B$2:$B$14="Sedan")+($B$2:$B$14="Electric"),$C$2:$C$14),ROWS($1:1)),$C$2:$C$14,0))

Enter with Ctrl+Shift+Enter


Copy across two columns to get Model and Speed and copy down 2 rows

You are a force of nature. Thanks so much.

That response even corrects my desired output in the post above yours.

[JohnTopley]

Thanks for the feedback.

If you have your required result, could you please mark thread as solved ("Thread tools" at top of first post).