Retrieving Data that meets a certian criteria

Hello,

I am trying to use a function that will retrieve data in the same order specified, for a certain criteria. The following is an example of what I am trying to accomplish:

The DATA:
Car Acc.
1 10
1 20
1 30
1 40
1 50
2 12
2 15
2 20
2 22
3 11
3 12
3 17
3 19
3 21
4 20
4 22
4 26
4 21

The table I am trying to produce:

_1 _2 _3 _4
10 12 11 20
20 15 12 22
30 20 17 26
40 22 19 21
50 21

Many Thanks

Hi

Assuming your data are in range A1:B12. In E1 type 1. In F1 type 2 etc.....

Then in E2 and copy down and across put this ARRAY formula.

PHP Code: 

=IFERROR(INDEX($B$1:$B$12,SMALL(IF($A$1:$A$12=E$1,ROW($B$1:$B$12)),ROW(B1))),"") 


-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.