| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count unige lines in a column based on a crieria in a other column
It would be appreciated if someone can assist with a formula. I have two colums A1:A26 (Purchase order heading) and B1:B26 (Num of devices). I need to calculate the unique numbers (Purchase Order) related to the number of devices.
Purchase Order Number of Devices 4501140744 2.00 4501140744 2.00 4501140744 2.00 4501140744 2.00 4501140744 2.00 4501140744 2.00 4501140744 2.00 4501173972 2.00 4501174428 2.00 4501174429 2.00 4501174599 2.00 4501175052 2.00 4501174733 2.00 4501174739 2.00 4501174743 2.00 4501175522 2.00 4501140744 2.00 4501140744 3.00 4501175510 3.00 4501172458 3.00 4501172458 3.00 4501172458 3.00 4501172458 3.00 4501176472 3.00 4501176793 3.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Based on Mulipple Criteria acrossed Column count last column | Excel Worksheet Functions | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Count entries in one column based on values in another column | Excel Worksheet Functions | |||
| SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions | |||
Threaded Mode
