Hi...
This is what I am trying to do...
I need to lookup the ID# and then add up all Ranks for the same ID#
For. E.g.
ID # 47 - Total Rank = 1+2+1+1 = 5
Can I use vlookup here?
Thanks in advance,
Dimbasco
This is what I am trying to do...
I need to lookup the ID# and then add up all Ranks for the same ID#
For. E.g.
ID # 47 - Total Rank = 1+2+1+1 = 5
Can I use vlookup here?
Thanks in advance,
Dimbasco
rank.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
15 | ID# | Type | Rank | |||
16 | 47 | A | 1 | |||
17 | 47 | B | 2 | |||
18 | 47 | C | 1 | |||
19 | 47 | D | 1 | |||
20 | 48 | B | 3 | |||
21 | 48 | C | 2 | |||
22 | 48 | D | 2 | |||
Sheet3 |