In article <5f67088fe7dd1@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Yes, it woud be great to have the criterion and numeric value returned in the
same cell.

In that case, try the following formula instead...

D2, copied across and down:

=IF(COLUMNS($D2:D2)<=$C2,$B2&"
"&INDEX(DataIdx,LARGE(IF(DataIdx=$B2,ROW(DataI dx)-MIN(ROW(DataIdx))+1),CO
LUMNS($D2:D2))-1),"")

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!