sorting question

  • Thread starter Thread starter kolonelvonklink
  • Start date Start date
K

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



thank
 
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
 
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
 
Back
Top