Hi Guys!
I am working now at a school project and I got a bit stuck. I was wondering if it is an easy way of doing this. Below you have an example of my data:
Column A
A
A
A
A
A
A
B
B
B
C
C
C
D
D
I want to multiply each value (these are names of companies) for exactly 24 times. I tried a few times myself and used a decreasing number and every time it hit 1 the function would have got the next value from the left and multiply it again 24 times. The only problem is that after some time the countdown missed some companies which obviously I do not want to happen. I am already trying to do this for about 4hr now and I do not know how what else should I try.
I would really appreciate your time!
Thank you!
Bookmarks