Hi everyone,
I'm trying to create a macro which will autofill column C with data located in column A and column B. Column A contains values while column B contains the # of instances that each value occurs in the data set. I want column C to autofill with values from column A based on the # of instances that the value occurs in column B. So for example if the value is 1.5 and the # of instances is 3, I want column C to autofill the value of 1.5 for 3 cells.
I have attached an excel file for you to look at. I'm very familiar with using functions in excel but I'm learning how to write macros for the first time. Thanks for reading and I hope to hear from you all soon!
Bookmarks