如何选择随机单元格避免空白单元格?

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

我需要在列中选择Excel中的随机单元格，同时避免空白单元格。

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

我不知道怎么做，看了帮助主题，但什么也没找到。范围在A1和A160之间

1 个解决方案

#1

In ColumnB and copied down to suit:

在栏内，抄写以适应:

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

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

A:B在B栏上，从A栏中选择和西装一样多的衣服。