I don't believe there's a simple formula solution but here's one
possibility...
assuming that your column headers in row 2 are all unique
this formula in A6
=INDEX($2:$2,MATCH(MAX($78:$78),$78:$78,0))
this formula in A7 copied down column
=IF(LARGE($78:$78,ROW()-ROW(A$6)+1)<LARGE($78:$78,ROW()-ROW(A$7)+1),INDEX($2:$2,MATCH(LARGE($78:$78,ROW()-ROW(A$6)+1),$78:$78,0)),INDEX(INDEX($2:$2,MATCH(A6 ,$2:$2,0)+1):IV$2,MATCH(LARGE($78:$78,ROW()-ROW(A$6)+1),INDEX($78:$78,MATCH(A6,$2:$2,0)+1):IV$ 78,0)))
note that you will need to amend the formulas accordingly if entered in
different cells
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=523973