Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort one coloumn according to another coloumn on another worksheet
Hi guys.
i am a newbie. i went through all the posts but couldnt inderstand. I want to sort coloumn A on worksheet 2 according to coloumn A on worksheet2. e.g Coloumn A ( Worksheet1) B | Column A (Worksheet 2 harry H david david D craig craig C harry smith S smith The contents of coloumn A will not be the same order every day. Could someone help me sort col A of worksheet 1 after matching it with the strings in colomn A worksheet2. The only criteria to sort would be mathcing the strings. i.e names the out put should look like: ( Worksheet1) (Worksheet 2 Coloumn A | Coloumn B || Column A david D david craig C craig harry H harry smith S smith Thanks in advance Sunir |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suming parts of a coloumn | Excel Discussion (Misc queries) | |||
split coloumn | Excel Worksheet Functions | |||
how i can protect few rows or few coloumn? | Excel Worksheet Functions | |||
How to search data in one coloumn | Excel Worksheet Functions | |||
about coloumn wide | New Users to Excel |