If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
count
Hi
This is a distribution report. with the following 3000+ 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 col A I have tried sub totals but can't get to count only different ones? Col A Col B GA1234. Ipswich GA1234. Norwich GA1234. Ipswich GA2345. B'ham GA2345.Stoke GA2345.Stafford GA2345.Stoke GA2345.Stoke Hopefully end up with the following result GA1234 = 2. GA2345 = 3 Any idea's or direction Regards Brian -- bnt Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...neral/200605/1 |
#2
|
|||
|
|||
count
This looks like an Excel question. Try posting it there.
"brian thompson3001 via OfficeKB.com" wrote: Hi This is a distribution report. with the following 3000+ 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 col A I have tried sub totals but can't get to count only different ones? Col A Col B GA1234. Ipswich GA1234. Norwich GA1234. Ipswich GA2345. B'ham GA2345.Stoke GA2345.Stafford GA2345.Stoke GA2345.Stoke Hopefully end up with the following result GA1234 = 2. GA2345 = 3 Any idea's or direction Regards Brian -- bnt Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...neral/200605/1 |
#3
|
|||
|
|||
count
sorry, thought i did
regards brian thompson3001 wrote: Hi This is a distribution report. with the following 3000+ 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 col A I have tried sub totals but can't get to count only different ones? Col A Col B GA1234. Ipswich GA1234. Norwich GA1234. Ipswich GA2345. B'ham GA2345.Stoke GA2345.Stafford GA2345.Stoke GA2345.Stoke Hopefully end up with the following result GA1234 = 2. GA2345 = 3 Any idea's or direction Regards Brian -- bnt Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...neral/200605/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Sam via OfficeKB.com | Worksheet Functions | 2 | March 20th, 2006 02:29 AM |
Get count of product with special feature at each store | robert d via AccessMonster.com | Running & Setting Up Queries | 1 | February 23rd, 2006 08:16 PM |
Conversion | SVC | Worksheet Functions | 9 | February 28th, 2005 02:29 PM |
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Sam via OfficeKB.com | Worksheet Functions | 8 | February 3rd, 2005 01:37 AM |
Joining two count results | Adam Pedder | Running & Setting Up Queries | 4 | June 14th, 2004 04:59 PM |