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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
You must log in or register to reply here.

Similar threads

M
  • Question Question
"Standard" lists of "random" numbers
Replies
5
Views
216
StephenCrump
S
P
  • Solved
Random predictions based on small number result (8 results predicted 125 numbers)
Replies
5
Views
263
Joe4
Joe4
D
  • Question Question
Conditional Formatting Help Needed!
2
Replies
15
Views
362
coulombevin
coulombevin
S
  • Question Question
Creating a random sequence of items from a weighted list with no duplicates
Replies
6
Views
498
shg
shg
P
  • Solved
Dynamically sum multiple columns, based on grouped criteria from another array
Replies
3
Views
680
Fluff
Fluff

Forum statistics

Threads
1,226,730
Messages
6,192,702
Members
453,748
Latest member
akhtarf3

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