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