Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select data onto new worksheet
I am trying to create a sheet (A) that lists the 20 largest (or smallest)
companies based on another sheet (B) that has a list of companies, and need help. The B sheet has, in each row, many different pieces of information about the company; there are more than 1,000 companies on the sheet. Some of the data listed are, for example, stock price and number of employees. On Sheet A, I'd like to have company name, city, state, number of employees, etc., but, for example, only for the 20 largest employers. I have used the =LARGE or =SMALL functions on Sheet A, looking in the number of employees column on Sheet B to get the number of employees, but I can't seem to get Excel to look across the Sheet B to find the company name or the other information tied to that number of employees that I want to display on sheet A. Using a PivotTable would create a monster-sized file; I am hoping there is a way to combine =LARGE with another function to select the additional data. Thanks in advance for your thoughts. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select and extract rows of data to new excel worksheet | Excel Worksheet Functions | |||
How do I use the data in a named field to select a worksheet tab . | Excel Discussion (Misc queries) | |||
SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
Move select data to another worksheet | Excel Discussion (Misc queries) | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions |