Hi all,

I am trying to match data in a formula and the cell contains an alpha
numeric value....with spaces...ughhhh

e.g. VK 1234 RAM which is in A2

What I need to retrieve is lookup the value in A2:A6, find exact match
to that value and ADD the totals of each value...

e.g.

A B C
VK 1234 RAM 18/07/06 2
VK 1234 RAM 20/07/06 5
VK 5678 RAM 18/07/06 3
VK 1234 RAM 18/07/06 5

RESULT I'm after would be

VK 1234 RAM 10
VK 5678 RAM 5

Can anyone help me?


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=565847