Get unique list of occurances & total value counts from a two column list?

[pubjay]

Not able to figure this out in an older version of excel.... =UNIQUE not availble.

Any help would be appreciated.

[BMV]

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

but pivote table can be beter for you

[pubjay]

I guess I don't know how to make it work. When I look at your example, it's there. Whe I try to replicate it in another tab of the example, doesn't work.

I just paste the =IFERROR into cell I2 and drag down? Or it should populate itself?

[pubjay]

Figured it out!

I guess you need to use CTRL + SHIFT + ENTER on the formula (array formula)

First time I've ever done that.

BMV your examples worked perfectly after that, thank you!