Return Greatest Count based on Criteria

[MHudson]

This should be a quick one, got me stumped. 3 Columns: Account Number, Product Code, and PO Count. Some of the product codes are blank, so I want to return the highest PO Count by Product Code for the same Vendor Number.

So, in the example below, I need to return the product code F1 to use for the blank product code in the 1st row. Also, this is a file with multiple Acct numbers (hence the criteria requirement). DAX solutions welcomed!

Acct# Prodcode POcount
315....(blank)....100
315....F1...........200
315....F2...........150
315....SG...........10

Thanks!

 

[Luke M]

So, we just need to fill in the blank cells? I think the formula would be something like
=IF(ISBLANK(B2),MAX(IF(A$2:A$100=A2,C$2:C$100)),B2)
Confirm formula as an array, using Ctrl+Shift+Enter, not just Enter.