Hi Guys, Hit a bit of a snag,
I have a table of Data (Table1), in Column C, of that Table I have lots of names, on a seperate worksheet, (sheet2)I have made a Data Valadation List of all the names used, what I need is depending on which name is showing in the data valadation list, a formula in an ajacient cell that will look at the name shown and count the number of instances the name occurs in Column C Table1 (to make things easier we will call this range "Names"), and each time I change the name the value should also change.
hope this is clear enough
Thank You In Advance
I have a table of Data (Table1), in Column C, of that Table I have lots of names, on a seperate worksheet, (sheet2)I have made a Data Valadation List of all the names used, what I need is depending on which name is showing in the data valadation list, a formula in an ajacient cell that will look at the name shown and count the number of instances the name occurs in Column C Table1 (to make things easier we will call this range "Names"), and each time I change the name the value should also change.
hope this is clear enough
Thank You In Advance
