| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
summary count of unique numbers
I am trying to create a supplier delivery performance spreadsheet and I need
to be able to show a count of the total number of unique orders placed for each supplier. The worksheet is sub-totalled on a count of the number of receipts made but one order can have one to many receipts. SuppNo OrderNo ReceiptNo 123 9961 1 456 9978 16 456 9982 33 789 9999 46 789 9999 57 Therefore SuppNo 123 has 1 Order(s) and 1 Receipt(s) 456 2 2 789 1 2 Can anyone help me please! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
| Count Unique Values | Excel Worksheet Functions | |||
| Count Unique in Pivot Table | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Threaded Mode
