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

sorting question
 

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

sorting question
 

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