Random Numbers in Excel Spreadsheet

[djeverett01]

I have a spreadsheet with two columns, A & B. In one(A) I want a random number and in the second(B) I want some data. What I am trying to do is if the second column(B) contains data then I want to add a random number to the first column(A). Is this possible. If so, does anyone know how to do this? I don't want to set a certain cell range because I don't know how many items will be added to the list.

 

[SkipVought]

Hi,

=IF(ISBLANK(B1),"",RAND())

hOPE THIS HELPS

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[djeverett01]

IT WORKS GREAT!!!! THANKS FOR THE HELP!!!