D
Diggsy
Hello,
I am trying to do a vlookup on Group Names and return a sum of the unique
values only. I have many Group names all over this sheet and much of this is
repeated (It is important for that sheet). However I just need to have a sum
of all unique values.
For example
Column A Column B
Group Name Number in Group
F8 20
F7 30
F7 5
F8 20
F7 10
F8 5
F7 30
F7 5
F8 15
F8 5
F8 15
The reu;lt would return a total of 40 for F8(20 + 15 + 5)
and a total of 45 for F7 (30 + 5 + 10)
Thanks
chris
I am trying to do a vlookup on Group Names and return a sum of the unique
values only. I have many Group names all over this sheet and much of this is
repeated (It is important for that sheet). However I just need to have a sum
of all unique values.
For example
Column A Column B
Group Name Number in Group
F8 20
F7 30
F7 5
F8 20
F7 10
F8 5
F7 30
F7 5
F8 15
F8 5
F8 15
The reu;lt would return a total of 40 for F8(20 + 15 + 5)
and a total of 45 for F7 (30 + 5 + 10)
Thanks
chris