View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kolonelvonklink kolonelvonklink is offline
external usenet poster
 
Posts: 1
Default sorting question


Hi
I'm not an expierienced user so this question

in page 1 I have

A B
1 house zorro dog
2 mouse car extra
3 bike rocket

How can I become automaticly in page 2

A B
bike 3
car 2
dog 1
extra 2
house 1
mouse 2
rocket 3
zorro 1

edit: the numbers schould be in collumn B



thanks


--
kolonelvonklink
------------------------------------------------------------------------
kolonelvonklink's Profile: http://www.excelforum.com/member.php...o&userid=37863
View this thread: http://www.excelforum.com/showthread...hreadid=574114