Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do u sort many items out a spread sheet in excel
I get an excel spread sheet hundreds of thousands of accouts on it. I have
a few thousand of the accouts myself i have to look at. I need a function or a table where i can put my accts numbers and can pull out the importation out i need. Any help on this would be a huge and i would greatly appericate. please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do u sort many items out a spread sheet in excel
So you want to use the account numbers on your sheet to reference the same
account numbers on the larger sheet and pull information for only those numbers into your sheet? Tough to come up with an exact formula without a more specific exampel of what your sheets look like but you would probably use the VLOOKUP function, it has the ability to search for the account # in the larger sheet that will match your account # and then return information from the larger sheet. "csuprano" wrote: I get an excel spread sheet hundreds of thousands of accouts on it. I have a few thousand of the accouts myself i have to look at. I need a function or a table where i can put my accts numbers and can pull out the importation out i need. Any help on this would be a huge and i would greatly appericate. please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i sort a spread sheet and remove duplication | Excel Worksheet Functions | |||
how do i enter a bull call spread into the options spread sheet ? | Excel Worksheet Functions | |||
How to sort by ZIP codes listed in one column in Excel spread sh? | Excel Discussion (Misc queries) | |||
How do I sort entire spread sheet. Names w/data | Excel Worksheet Functions | |||
How do i sort items using two rows per item in Excel? | Excel Discussion (Misc queries) |