Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting data
How can I search all the required data say some 'A'from a list of data where
'A' is at some different locations. How can i use Vlookup for this or is there any other method I need to get all this data at one place, say suppose i input A again in another sheet or same sheet 6th column, how can i get all the data of A at one place Like in the following example: A 78 4 6 37 8 B 1 5 6 7 7 C 5 8 9 6 4 A 67 8 8 5 9 B 7 9 9 0 6 I should get something like: A 78 4 6 37 8 A A 78 4 6 37 8 A 67 8 8 5 9 B 1 5 6 7 7 C 5 8 9 6 4 A 67 8 8 5 9 B 7 9 9 0 6 When I input A I should get teh data present in A that is present in teh main list in successive rows |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Data | Excel Worksheet Functions | |||
Help please - Data sorting | Excel Worksheet Functions | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
Help Help - Sorting Data | New Users to Excel |