Jus enquiring about auto-filtering in excel. I have a list of name on a drop down list! When i filter these i want to get a total of the name that i have filter! I then wish to automatcially modify data in a chart whenever i have selected anything in the auto-filter!Can this be possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Automatically modify a chart with Auto-Filter?
- Thread starter owendodd
- Start date
The Tamer
Well-known Member
- Joined
- Jun 10, 2004
- Messages
- 520
Hi
Say you have your list of names in A1:A1000. Leave a couple of rows blank and insert the formula:
=SUBTOTAL(3,A1:A1000)
This will show you a count (COUNTA) of all the filtered data on your sheet. You can link your charts to such formula and they will change depending on what you filter.
HTH
Tamer
Say you have your list of names in A1:A1000. Leave a couple of rows blank and insert the formula:
=SUBTOTAL(3,A1:A1000)
This will show you a count (COUNTA) of all the filtered data on your sheet. You can link your charts to such formula and they will change depending on what you filter.
HTH
Tamer
Upvote
0
Similar threads
