Hi - can anyone help me with a little problem?
I have 2 x Columns. In Column A there is a list of IDs, which represent when a particular person has visited a given website. If someone clicks on multiple web pages, the same ID will appear multiple times in Col A.
Each website receives a numerical score, so in Col B each ID will have an associated score alongside it.
Let's imagine a guy clicks on 3 web pages, so he is represented by 3 x rows - with the same ID each time in Col A, but scores 5, 10, 15 alongside those IDs in Col B.
There are thousands of rows, so I'm trying to get to a formula that I could use in Col C, that would identify each row sharing the same ID, then return the total score for that particular person/ID........so against each of the 3 rows for this example ID, I would expect to see the same total score returned - 5+10+15=30! See example below:
A B C
ID Score Total Score
1234 5 30
1234 10 30
1234 15 30
Hope this makes sense. I need to deliver the score into Column C.
Thanks in advance
Desmond
Bookmarks