Count PO's per Supplier

[jlp]

I know this has been asked a number of ways and I feel I have got myself so convoluted with so much information I cannot make heads or tails out of how I need to write this formula

I have a spreadsheet

Suppl Name	PO
Supplier A	41058
Supplier A	41099
Supplier A	41099
Supplier A	41166
Supplier A	41271
Supplier B	41059
Supplier B	41059
Supplier C	41052
Supplier D	41136
Supplier E	41157
Supplier E	41168
Supplier F	41139

I want the number of unique PO's per Supplier, such as:
Supplier A 4
Supplier B 1

For the life of me I cannot figure out how to do this.

Please help!

 

[Joe4]

Ugh...I get what you're saying but now I'm getting a "1".

Is this an Array formula requiring Cntl+Alt+Enter?

No, can you post a screen shot of your sample data and formula results, sort of like what I did?
And if you changed the formula at all, please show us that.

 

[jlp]

No, can you post a screen shot of your sample data and formula results, sort of like what I did?
And if you changed the formula at all, please show us that.

The formula hasn't changed I'm using the one from above: =LET(a,CHOOSECOLS(UNIQUE($A$2:$B$13),1),COUNTA(FILTER(a,a=$E2)))

 

[Joe4]

What exactly is the formula you have in cell F2?

 

[jlp]

What exactly is the formula you have in cell F2?

=LET(a,CHOOSECOLS(UNIQUE($A$2:$B$13),1),COUNTA(FILTER(a,a=$E2)))

 

[Joe4]

Hmmm...

Does it make any difference if you hit the F9 key (to recalculate)?

What does the following formula return, if you enter it into any blank cell?

=COUNTIFS(A2:A13,E2)

 

[jlp]

Hmmm...

Does it make any difference if you hit the F9 key (to recalculate)?

What does the following formula return, if you enter it into any blank cell?

=COUNTIFS(A2:A13,E2)

F9 didn't do anything...I copied your formula into G2 - below are the results

 

[Joe4]

This makes no sense. You are using Excel 365, right?

Would you be able to upload a copy of this file to a file sharing site for us to investigate directly?
If you are, just upload it and provide the link here.

 

[jlp]

This makes no sense. You are using Excel 365, right?

Would you be able to upload a copy of this file to a file sharing site for us to investigate directly?
If you are, just upload it and provide the link here.

Thank you so much for you help Joe - I'm leaving work shortly and can send you the spreadsheet tomorrow.

I'm thinking of opening a new spreadsheet and trying this from the beginning in case there is some "gunk" hanging around in the spreadsheet.

I will let you know. Meantime, here is the version of Excel we are running.

 

[jlp]

Good morning! - I tried remaking the spreadsheet and I received the same results - I tried loading the xl2bb Add-In to my Excel, unfortunately I do not have the credentials to do this.

I am not familiar with File Sharing sites.

 

[Joe4]

I am not familiar with File Sharing sites.

There are a number you can use. Some people use their own OneDrive accounts, etc, but there are other common free ones that people use, like DropBox.