'Top 3' from master list

I am looking to have a master list with following columns:
index (#) | issues (text) | resolution (text) | severity (#) | status (open/closed)

This is all manually entered.

On another sheet I then want the top 3 of these (defined using a combination of 'highest severity' and 'open' displayed like this:

1 | Issue
| Resolution
2 | Issue
| Resolution
3 | Issue
| Resolution

I've tried using Match to get the reference but I would appreciate some pointers as I need to complete it today and had another load of work just pile on top!

Any help much appreciated

If you are looking for a speedy response, it would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

Thanks, please see attached.

I've manually populated it to what I would like it to look like with the highest severity risk at #1 and so on, but only showing 'open' risks.

I have got the top 3 open severities using LARGE on a product of
=IF(STATUS='open',1,0) * severity

This gives me the top 3 open severities, but as there may well be duplicate severity values, I can't then use this to VLOOKUP back to the descriptions.

http://forum.chandoo.org/threads/fin...-solved.10675/

This is the closest I can get to a solution - I would rather something a little more elegant!

http://forum.chandoo.org/threads/fin...-solved.10675/

This is the closest I can get to a solution - I would rather something a little more elegant!