Hi, I've been trying to produce the factors of a number into a single cell. I have found the one for outputting them into a column, but need a few thousand, so cant have it in this format. I need randbetween(1,100) in column A and the factors in B. So A1=12 B1=1,2,3,4,6,12. The commas don't necessarily need to be there.
I also will need in the next step produce Prime factors in one single cell. Eg A1=12 B1=2, 2, 6
Sorry if it's been asked before, but I've had a search and can't quite find what I need.
Thanks in advance!
Bookmarks