Multiple Selection in dropdown

[rrahul127]

Hi All,

Greetings!

I am preparing a Sales Dashboard and I am stuck in making multiple selection option in the drop-down. With using this drop-down user can see total (sum) of multiple locations.

Excel is attached, please help me.



Best Regards,
Rahul Sharma

[than_gold]

Hello Rahul,
You can check out here for multiple drop down lists & do vlookup to get the sum of values.
https://www.contextures.com/excel-da...-multiple.html

[Glenn Kennedy]

It can also be done more simply, without using VBA. I replaced your named range with one called List:


=Sheet1!$Q$2:INDEX(Sheet1!$Q$2:$Q$100,SUMPRODUCT(--(LEN(Sheet1!$Q$2:$Q$100)>0)))

I used List as the DV list.

The formula for the total was:

=SUMPRODUCT(SUMIF($A$2:$A$100,$H$4:$H$6,$B$2:$B$100))

see sheet. The stuff in cols O, P & Q can be hidden, or placed on a hidden sheet, or whatever...

[avk]

Go to data > Data Validation >Select List > in source type a,b,c,d,all > ok
In "I1"

Please Login or Register  to view this content.

[rrahul127]

Is that possible to insert tick box for multiple selections? (like filter option in a pivot table)

[avk]

Yes it is possible but using vba macro.
I am not familiar with vba. some one may help.