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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You must log in or register to reply here.

Similar threads

P
  • Solved
Random predictions based on small number result (8 results predicted 125 numbers)
Replies
5
Views
140
Joe4
Joe4
P
  • Solved
Dynamically sum multiple columns, based on grouped criteria from another array
Replies
3
Views
456
Fluff
Fluff
R
  • Question Question
How to summarize repeated calculations using rand()
Replies
3
Views
223
roscoe
R
M
  • Solved
Please help to code has debug.
Replies
5
Views
281
motilulla
M
Livin404
  • Solved
Random numbers add pointless decimals at end of whole number
Replies
4
Views
339
Livin404
Livin404

Forum statistics

Threads
1,223,237
Messages
6,170,924
Members
452,366
Latest member
TePunaBloke

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