| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count
Hi
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 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...excel/200605/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Threaded Mode
