I have a first column say named as 1 to 100. I want to enter a random number from 1 to 100 in the second column and the corresponding on the first column shall be deleted immediately. How do I write a formula to do this activity?