Validation issue

[3link]

Here's what I'm trying to do. It's easiest to get this if you look at the attached spreadsheet (no macros in it).

I have a column (like F in the attached spreadsheet) that is restricted to a list by validation (like the list in column I). This list is special because it updates every time a selection is made. For instance, every time I select "Test A" in column F, that is counted (see countifs starting at E23) and added to the total in the parentheses next to "Test A" on the list. As a result, the list is updated. The next time you activate the list from one of the cells in column F, "TestA" will appear with the updated number in parentheses. Feel free to play around with the validation in column F until you see what I'm talking about.

My objective is this: I want a validation list that updates and displays just like in column F. However, I want to make it so that after a user makes a selection from the list, the validated cell will only display the test and its corresponding letter - not the number in parentheses (like in column E). In other words, were I to select "Test A(3)" from the dropdown list, I'd only want the validation cell to display "Test A".

Has anyone tried anything like this?