I have searched high and low, I am looking to repeat a list of names by the number of ballots each individual has purchased. I am doing a draw for work and do not want to repeat each name manually into separate cells. Is there a formula for this? Can the rept function have the data repeated into separate cells?
Bookmarks