Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data sorting
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data sorting
If you have the existing data organised in a flat file, you might filter the
table for A, B and so on. "vijaya" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data sorting
How can I make it as a flat file, well what is a flat file?? "Suresh" wrote: If you have the existing data organised in a flat file, you might filter the table for A, B and so on. "vijaya" wrote: 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 | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
Sorting data using roman numerals.... | Excel Discussion (Misc queries) | |||
Sorting Data question | Excel Worksheet Functions | |||
Sorting Data from 2 sheets, one sheet which is already sorted | Excel Worksheet Functions | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |