ExcelEveryday
New Member
- Joined
- Jan 13, 2015
- Messages
- 9
Hi all,
I would like to be able to pulldown a formula to retrieve a list according to several criteria from a huge dataset.
so for example, I would have Year, Quarter, company and sales
I would need a pulldown formula that would give me all sales for a particular company for a particular quarter and year. The kicker is that the same companies have multiple sales instances for the same quarter for the same year, so I dont know how to retrieve all those values with the formula. The criteria for all sales are the same, but the sales instances are different. The pulldown list wouldn't be able to have any blanks, only results.
EX:
<tbody>
</tbody>
Output for a pull down list for sales for abc for q1 year1 would be
120
90
Ive been browsing the net, but I still dont seem to understand how I can do this with a formula. Help me Excel pros!
I would like to be able to pulldown a formula to retrieve a list according to several criteria from a huge dataset.
so for example, I would have Year, Quarter, company and sales
I would need a pulldown formula that would give me all sales for a particular company for a particular quarter and year. The kicker is that the same companies have multiple sales instances for the same quarter for the same year, so I dont know how to retrieve all those values with the formula. The criteria for all sales are the same, but the sales instances are different. The pulldown list wouldn't be able to have any blanks, only results.
EX:
company | Sales | Q | Year |
abc | 120 | 1 | 1 |
abc | 90 | 1 | 1 |
efg | 5 | 2 | 2 |
<tbody>
</tbody>
Output for a pull down list for sales for abc for q1 year1 would be
120
90
Ive been browsing the net, but I still dont seem to understand how I can do this with a formula. Help me Excel pros!