Hello, I'm trying to use VBA to sum values in COL F and delete duplicate rows when the data in COLs A through D all match in other rows. The sum would replace the topmost value in COL F, and also replace the value in COL E to represent that multiple divisions are represented in the total. (the values in COL E are still important where there are no duplicates of other data).
I thought of trying a combination of concatenation of the data in COLs A:D as a SUMIF criteria, but can't figure out how. Any other suggestions would be most appreciated.
A B C D E F
1 Fall 2018 Company A 393090406 ALB 1 11
3 Fall 2018 Company A 393265149 SAN 1 80
4 Fall 2018 Company A 393265149 SAN 2 80
5 Fall 2018 Company A 393265149 SAN 7 73
Becomes:
A B C D E F
1 Fall 2018 Company A 393090406 ALB 1 11
2 Fall 2018 Company A 393090406 SAN 1 80
3 Fall 2018 Company A 393265149 SAN MULTI 233
Bookmarks