Generating Random Sample Data in Numbers

If you are building a spreadsheet in Numbers it can be useful to have sample data to help construct your tables and get things right before you have real data to enter. You can use the RANDBETWEEN function to create random numbers. Then if you copy and paste correctly you can turn those formulas into static numbers that won't change.

Comments: 3 Responses to “Generating Random Sample Data in Numbers”

    Joel
    3 years ago

    I often have to work also in Excel (please don’t hit me), but I don’t know if such a formula exists there. Do you?

    3 years ago

    Joel: In Excel it is the same function (RANDBETWEEN). Then you Edit, Paste Special and choose to paste the values.

    Joel
    3 years ago

    Thanks. I’ll definitely have need for that.

Comments Closed.