L
Ledge
Hi Folks, Hoping I could get some guidance with this:
I have 3 columns of data on sheet1.
Column A is numerical "APN"
Column B is text "Product Description"
Column C is numerical "Total"
Is there a way to search column A for multiple matching entries and if
so to sum the total while reducing back to one entry?
EG: SHEET CURRENTLY LOOKS LIKE THIS
APN Product Description Total
25454 AAA 2
32121 BBB 1
32654 CCC 2
25454 AAA 5
WOULD LIKE IT TO DO THIS
APN Product Description Total
25454 AAA 7
32121 BBB 1
32654 CCC 2
This one is beyond my skills and would appreciate any assistance.
Thanks for your time.
Dean
I have 3 columns of data on sheet1.
Column A is numerical "APN"
Column B is text "Product Description"
Column C is numerical "Total"
Is there a way to search column A for multiple matching entries and if
so to sum the total while reducing back to one entry?
EG: SHEET CURRENTLY LOOKS LIKE THIS
APN Product Description Total
25454 AAA 2
32121 BBB 1
32654 CCC 2
25454 AAA 5
WOULD LIKE IT TO DO THIS
APN Product Description Total
25454 AAA 7
32121 BBB 1
32654 CCC 2
This one is beyond my skills and would appreciate any assistance.
Thanks for your time.
Dean