Roderick_E
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 2,051
Ok, some reason I can't remember this simple VBA code (Excel 2003-2010).
Suppose you have column A and B, 5 to 11.
In column C you want the cumulative result of matches to column A (result = column B elements)
COLA COLB
CN 5
US 6
CN 7
US 8
CN 9
UK 10
CN 11
In column C I want
COLC
5,7,9,11
6,8
5,7,9,11
6,8
5,7,9,11
10
5,7,9,11
As you can see, these are cooresponding with matching column A to colum A.
For X = 5 to 11
....
Next X
Suppose you have column A and B, 5 to 11.
In column C you want the cumulative result of matches to column A (result = column B elements)
COLA COLB
CN 5
US 6
CN 7
US 8
CN 9
UK 10
CN 11
In column C I want
COLC
5,7,9,11
6,8
5,7,9,11
6,8
5,7,9,11
10
5,7,9,11
As you can see, these are cooresponding with matching column A to colum A.
For X = 5 to 11
....
Next X