Random & refresh

  • Thread starter Thread starter JVS
  • Start date Start date
J

JVS

Is it possible to lock some cells so that they do not refresh?
I am using Randbetween to generate a starting order for a race.
and use other formulas to advance the winners to the next bracket.
I need to lock out the starting order so that it does not refresh as the
winners advance.

Any thoughts or suggestions are welcome.

Thanks!
xjvs
 
JVS

My suggestion is to copy/paste values on those cells you don't want refreshed.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Name 13
Create random list - dublicates are okay but not right after each other 2
Formula to compare multiple cells 7
excel external data range "failed to refresh" 0
Random Letter Generator 4
Linking to files with a formula 3
excel external data range failed to refresh - second try 1
Weighted Random Selection 5

Back
Top