|Topic:||Excel sorry another question|
|Posted by:||George Turner|
|Thanks again to those who have helped me in the past....|
Now I need to have a routine/VBAE code to count the unique occurrences of 2 variables matching next to each other in different columns ie cells - I suspect I'm not explaining this well so here's a simple example:-
col A col B duplicate ?
apples trees yes
bananas trees yes
Therefore in the above the unique count would be 5. Sorry the layout of the columns gets mucked up.
But I need to do this with loads of data - any ideas?
|Topic||Date Posted||Posted By|
|Excel sorry another question||27/04/15 11:29:00||George Turner|
|Re:Excel sorry another question||27/04/15 11:38:00||Matteo Castagna|
|Re:Re:Excel sorry another question||27/04/15 12:46:00||George Turner|