Forum Message

Topic: Excel sorry another question
Posted by: George Turner
Date/Time: 27/04/15 11:29:00

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
raspberries  bushes
bananas      trees
apples       trees    yes
pears        trees
strawberries plants
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?

thanks


Entire Thread
TopicDate PostedPosted By
Excel sorry another question27/04/15 11:29:00 George Turner
   Re:Excel sorry another question27/04/15 11:38:00 Matteo Castagna
      Re:Re:Excel sorry another question27/04/15 12:46:00 George Turner

Forum Home