Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SORTING question | New Users to Excel | |||
sorting question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Sorting Question | Excel Discussion (Misc queries) | |||
Question about sorting in protected worksheet | Excel Worksheet Functions |