Count unige lines in a column based on a crieria in a other column

A

Andrew Pappas

It would be appreciated if someone can assist with a formula. I have tw
colums A1:A26 (Purchase order heading) and B1:B26 (Num of devices).
need to calculate the unique numbers (Purchase Order) related to th
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.0
 
S

Spencer101

Andrew said:
It would be appreciated if someone can assist with a formula. I have tw
colums A1:A26 (Purchase order heading) and B1:B26 (Num of devices).
need to calculate the unique numbers (Purchase Order) related to th
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
Click to expand...

I'm not 100% sure what it is you're actually asking for. Could yo
explain a little more
 
Top