Formulae help please?

A

Andy Moore

New Member
Joined
Mar 29, 2012
Messages
24
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have a =rand()25 formula entered into a cell, which is copied across the row. Is there a way that I can tell the formula not to repeat the rand result in the whole row?

Many thanks

Andy

:)
 
Sort by date Sort by votes
Absolutely brilliant effort guys. Many thanks for this. I did think it would be easier than this though!

Regards,

Andy

:)
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You must log in or register to reply here.

Similar threads

M
  • Question Question
"Standard" lists of "random" numbers
Replies
5
Views
110
StephenCrump
S
P
  • Solved
Random predictions based on small number result (8 results predicted 125 numbers)
Replies
5
Views
171
Joe4
Joe4
S
  • Question Question
Creating a random sequence of items from a weighted list with no duplicates
Replies
6
Views
326
shg
shg
P
  • Solved
Dynamically sum multiple columns, based on grouped criteria from another array
Replies
3
Views
560
Fluff
Fluff
R
  • Question Question
How to summarize repeated calculations using rand()
Replies
3
Views
231
roscoe
R

Forum statistics

Threads
1,224,824
Messages
6,181,187
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top