Hi Guys,

I am looking for something in R, where assume we have a 24 columns with some random values, also assume post 12th column, every columns are blank.

Now, I punch in a number, like to test, assume, if it is 10, it will check, whether do you have any values beyond 10th column, if it is 20, it will check whether do you have any values beyond 20th column. Can you guys help me out in excel or R. I think a loop needs to be created.

Thanks,

Sachith