Forum Message

Topic: Re:Excel sorry another question
Posted by: Matteo Castagna
Date/Time: 27/04/15 11:38:00

Before I try with something "interesting", a "brute force" approach could be to create a third column =colA&colB (please make sure you trim all the spaces) and then sort on that column. A fourth column should test if the preceding row is equal to the current one.
Those with FALSE are unique. You can assign then FALSE = 1 and sum across that column.
Very basic but it should work.


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