|Posted by:||brian thompson3001 via OfficeKB.com (u156…@uwe)|
|Date:||Wed, 03 May 2006|
This is a distribution report. with the following 2000+ rows and10 cols. One
column headed "load number "contains a number that is the same for 1,2,3,4,5,
6,7,8 or 9 rows, unfortunately this not constant. What I am attempting to get
is the number of different delivery points (col B) for each load number in
I have tried sub totals but can't get to count only different ones?
Col A Col B
Hopefully end up with the following result
GA1234 = 2.
GA2345 = 3
Any idea's or direction
Message posted via OfficeKB.com