I'm looking to see if there's a formula that solves the problem below.
In column A, I have a series of application I.D.s; some can appear once, some twice, some three times etc...there is no way of knowing in advance how many times an application I.D. will appear.
In column B, I have a...