Hello,
Someone please explain how to track selections from a dropdown menu, I have 8 selections under the dropdown that are being selected from a list. Next to the list I want to have the total of the number of times it was selected on the dropdown. I've tried the data>subtotals, but It only seems to create 0's under the dropdown box. I dont want the totals in the dropdown box I want it next to the list of 8. Sorry if this is confusing, but any help would be wonderful. Thank you.
Last edited by curtjer; 03-27-2009 at 02:20 PM.
curtjer,
You could use the Worksheet_Change Event.
I do have workable code, but it would be better to have your workbook.
Please post your workbook - scroll down and see "Manage Attachments".
Have a great day,
Stan
Last edited by stanleydgromjr; 03-26-2009 at 06:12 PM.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
curtjer,
Check out the attached workbook.
Have a great day,
Stan
solution
=COUNTIF(E2:E501,G4)
E2:E501 is range if dropdown is selected. G4 is the Name which I want tracked. Thank you though!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks