| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct with duplicates in two columns
I have 4 identical sheets that have same columns,different data.In each sheet
column B has dates,and column G has order numbers,(see example below),I want to know the number of days an order took place. B G 2-Jan-09 678 2-Jan-09 555 3-Jan-09 678 4-Jan-09 555 4-Jan-09 678 4-Jan-09 678 So number of days for order 678 is 3 and for order 555 its 2.Note that order 678 or 555 could appear in more than one sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT DUPLICATES | Excel Worksheet Functions | |||
| Compare columns for duplicates | New Users to Excel | |||
| Check for duplicates in 2 columns | Excel Worksheet Functions | |||
| HOW TO LOCATE DUPLICATES ON TWO COLUMNS | Excel Discussion (Misc queries) | |||
| Identifying Duplicates in Columns | Excel Worksheet Functions | |||
Threaded Mode
