Drop Down List Function

Hi,

The spreadsheet includes all business types; however I wat to have some type of lever (drop down) which users can select/deselect and get the desired results something shown in sheet.

Select Toronto Office Business Type excluding Farm and Farm B
Select Atlanta Office Business Type excluding Farm and Farm B

Any help would be highly appreciated.

Kind regards,
Sal

Thanks Speshul, but it does not allow calculations; is there some sort of conditional formatting required to exclude certain calculations based on selections made in drop down list?

Test File - Drop Down Selection Options.xlsxI may not want drop down but a pivot table maybe where I can select certain calculations...I am a novice hence do not know which functions in Excel would best help me in achieving my goal.

I am attaching the file for easy reference, the first set is ALL IN example.

I want to go to either Option A (which allows deselection of only one type of business in both branches) but it would be great if I can get some help in creating Option B type where I can select/deselect different types of businesses within each branch.

HI,

Check this file let me know whether it is working fine for u or not ?

Punnam

HI,

Find the updated sheet as per u r requirement.

Punnam

Pl see attached file.

Thanks a lot Punnam.....I am looking to use only one table. I have recreated the sample sheet so I can make myself a little bit more clear.

Can you do something like this in the table below (A5:I10)?

Exclude Bike, Car and Truck etc., Can this be a multiple selection drop down?

In this way the users will have flexibility to exclude any categor(y)ies from the selection to see the results?

I like the idea provided by kvsrinivasmurthy above, only thing is that it has too many repititions for end users in row 4. If we can make it easier for end users it will be of great help.

Thanks a lot. I am trying to seek solution like this...can you please see attached file whenever you have time.


Can I have something like this:

Select type of Business (Drop Down Multiple Selection Box in Cell F4, where I can select multiple type/s, and based on selections there should be no data in C9 to I12, and K9 to Q12 and also it should exclude in totals too?


Thanks....

Pl see the file attached file in above post. I have changed formula slightly.

Hi,

Refer my post 8 i have updated it with Drop down i am afraid multiple vale in on validation is not possible.

Punnam

Thanks a lot folks....really appreciate all your help and guidance.

Hi,

if u r question answered and solved mark the thread as solved .
U can thank any one who helped you by adding some reputation points by clicking the "star Symbol" Button.
Punnam