Hi guys,

I am completely stuck with this problem; any help would be much appreciated!

So i want to do the following in VBA:

Name Value Solution
x 5 1
x 64 3
x 30 2
y 19 1
z 47 4
z 36 2
z 27 1
z 36 2

Obviously the number of names in the first column would vary from one day to another.
Can you please help?

Thanks!