CODEWITHSUNDEEP
excelrandomexcel-formula
Alan
Alan

Reputation: 11

How to select random cell avoiding blank cells?

I need to select random cells in Excel inside a column while avoiding blank cells.

I don't know how to do this, looked at the help topics but could not find anything. The range is between A1 & A160

Upvotes: 1

Views: 752

Answers (1)

pnuts
pnuts

Reputation: 59475

In ColumnB and copied down to suit:

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

sort A:B on ColumnB and select as many from ColumnA as suits.

Upvotes: 1

Related Questions