Rank then sort then pastelink
Got it. great. thanks
"Bernd P" wrote:
Hello Sue,
If your fruit data resides in A2:A7 and the count data in B2:B7 then
enter into C2 (C being a helper column):
=COUNTIF($B$2:$B$7,""&B2)+COUNTIF($B$2:B2,B2)
and copy down to B7. Please note the correct "$" chars!
Enter into D2:
=INDEX($B$2:$B$7,MATCH(ROW()-1,$B$2:$B$7,))
and copy down.
Enter into E2:
=INDEX($A$2:$A$7,MATCH(ROW()-1,$B$2:$B$7,))
and copy down again.
Regards,
Bernd
|