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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Problem - Use Total Count in Other Formulas 0
Extracting Terms and Exponents of a Text Poly Formula ?? 4
SUMPRODUCT - Creating a weighted score in column with subtotals 3
Filter on non-blanks in a range (multiple columns) 1
How do I lookup the number of unique values from a list? 0
Copy rows to new sheet based on value in column A 0
Return number OR sum based on two criteria 2
Unique entries based on condition - count distinct 1

Top