Hello. My list contains names and a number next to the person's name that updates based on a count. How can I make the cells that have that name selected update automatically to reflect the count number?
D10 reads: ="Jane ("& E10 &")"
E10 Reads: =COUNTIF($E$5:$E$7,"*Jane*")
and E5:E7 are data validation lists.
The problem I have is that D10 and E10 update as expected but I want a way to have E5:E7 update their count as well without having to choose the item from the list twice.
excel help.png
DV operates in the same way as if you had manually typed in the contents - there is no underlying formula there.
So, based on that, if cells contain data that was selected from DV, there is no way to have then update automatically, the way you want.
If you need them to update, why even select them in the 1st place? Why not just have a formula to do the count instead? Or, if that is not an option, get the name (only) via DV, and in an adjacent cell, reference that DV along with a countif based on that DV
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks