sorting question

[kolonelvonklink]

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

[Naveen]

Change primary data in "Sheet1" as follows:
A B
house zorro dog 1
mouse car extra 2
bike rocket 3


and use this in second sheet:
=VLOOKUP("*"&A1&"*",Sheet1!$A$1:$B$3,2,0)
and copy same to remaining cells



"kolonelvonklink" wrote:

>
> 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
>
>

[Muhammed Rafeek M]

you can also try this one:
=INDEX(Sheet1!A:A,MATCH("*"&A1&"*",Sheet1!B:B,0),1)
once you enter this function press Ctrl+Shift+Enter key. bcos this is an
Array function

"kolonelvonklink" wrote:

>
> 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
>
>