I have the following sample sheet
I want to identify the item ranked by fail value for each test subgroup?
The test groups are not the same size.

test item fail
1 1 10.3
1 3 10.1
2 1 100
2 2 99
2 3 101
2 4 100
3 1 112
3 2 111
3 3 109

ideal output:

test item fail rank
1 1 10.3 2
1 3 10.1 1
2 1 100 2
2 2 99 1
2 3 101 3
2 4 100 2
3 1 112 4
3 2 111 3
3 3 109 1

I don't want to have to sort the columns - there are 1000's of rows and it
wouldn't be able to identify the worst failure case with a =if(rank=1.. test.

Currently I do it by exporting the table to Access and easily find the
min/max etc of a group - but then I need to re-export back to Excel to do
more calculations. The copy/pasting takes several minutes!

Suggestions comments welcome!
Z