Hello,
I have a formula in columns C, G, and K that counts the number of times a name as it is exactly shown in column Q in the data sheet appears. This list of names changes frequently and each time I add a name, I need to change the name in each column manually. I am trying to have the formula pickup the name automatically so that when I add, delete, sort, I will not need to manually update any of the name in the formula. Your help is greatly appreciated.
Thank you!