WooYing
asked on
Complex Excel (Somewhat)
I recently created an excel spreadsheet with a list of vendors and payments I have made.
What I am looking for do is bring create a drop down list and it will bring all those vendors into one area and give me a total cost.
For Instance
A B C D E F
1 Location Type Month Year Amount Vendor
2 New York Data 11 2013 100.00 Time Warner
3 Ohio Voice 11 2013 55.00 Verizon
4 Oregon Data 12 2013 65.00 AT&T
5 New York Data 1 2014 101.50 Time Warner
6 New York Voice 1 2014 55.00 Verizon
So If I want to create a drop down that if I wanted to select New York it will bring the entire row (1 and 5) and add the amount together and filter them. Same with Month or Year, I want it so it adds it up totally. Also same with Vendor, if I choose a vendor I want it all to show up and break it down. I know I can use the filter option but I am looking out of that so an drop down can happen and also it be nice to have a pie chart added as well would be a plus.
What I am looking for do is bring create a drop down list and it will bring all those vendors into one area and give me a total cost.
For Instance
A B C D E F
1 Location Type Month Year Amount Vendor
2 New York Data 11 2013 100.00 Time Warner
3 Ohio Voice 11 2013 55.00 Verizon
4 Oregon Data 12 2013 65.00 AT&T
5 New York Data 1 2014 101.50 Time Warner
6 New York Voice 1 2014 55.00 Verizon
So If I want to create a drop down that if I wanted to select New York it will bring the entire row (1 and 5) and add the amount together and filter them. Same with Month or Year, I want it so it adds it up totally. Also same with Vendor, if I choose a vendor I want it all to show up and break it down. I know I can use the filter option but I am looking out of that so an drop down can happen and also it be nice to have a pie chart added as well would be a plus.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.