Largest Value Based On Multiple Criteria

[Woody Pecker]

This one seems so simple but I've been banging my head against a brick wall.

I have a table of data.
In column A I have account names which could be duplicated many times.
In column B I have account references which relate to the account names in column A, these also are duplicated many times, but a particular ref could relate to many account names.

What I want to do is report back the largest string reference from column B that relates to any given account name in column A.

Surely it can't be that hard, but I'm just lost.

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.
Also please post some sample data, along with expected results using the XL2BB add-in.

 

[Woody Pecker]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.
Also please post some sample data, along with expected results using the XL2BB add-in.

Currently using Microsoft Excel 365 ProPlus, regretfully I can't post the sample data due to the sensitive nature of the data.

 

[Fluff]

Can't you mock-up some realistic sample data that is not sensitive?

 

[Woody Pecker]

Sorry I just don't have the time with my current work load, thanks for listening though, I wil;ltry & solve it myself