Hi,
This is a basic question but I’m wondering what the quickest way to sum column 3 based on column 1 AND column 2 using VBA.
Col1 contains first name, col2 second names, col 3 contains a number.
Where first and last names match, sum column 3.
I figured I should produce a list of uniques (by column1 and 2) but from there I got a little stuck on exactly what method to use
Any suggestions would be appreciated
Thanks!
This is a basic question but I’m wondering what the quickest way to sum column 3 based on column 1 AND column 2 using VBA.
Col1 contains first name, col2 second names, col 3 contains a number.
Where first and last names match, sum column 3.
I figured I should produce a list of uniques (by column1 and 2) but from there I got a little stuck on exactly what method to use
Any suggestions would be appreciated
Thanks!