Increasing numbers randomly, yet leave empty cells empty.

[X82]

I have a very specific situation I need help with.
I have this spread sheet containing about 300 rows of people. In some, not all columns, there is a number. Is there a way of making all those numbers increase or decrease by a random amount. Say if one column was 88 then after this it would be 74 or 93. I've tried RAND however, where columns have no data, I want it to remain blank. But putting a rand in all the cells it generates a number. And selecting all the cells I want to change would be tiresome.

Any thoughts?

 

[Sandeep Warrier]

Hi

If you already have data in some cells, and the other cells are actually blanks, then select your data range. Ctrl+H to open the Find/Replace box. Under Find What put *, and under Replace with put in the formula =RAND() ..... or if you prefer, =RANDBETWEEN(50,100) ... change the numbers to suit..... Click Replace All.

 

[VoG]

Perhaps: press F5, click Special, tick Constants and Numbers. Type your RAND formula, hold down CTRL and press Enter.