ExcelBanter - calculating 10 percentage of items in a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - calculating 10 percentage of items in a column (https://www.excelbanter.com/excel-discussion-misc-queries/42042-calculating-10-percentage-items-column.html)

ysymon

calculating 10 percentage of items in a column

we have a hand receipt worksheet that contains items assigned to each
custodian. how can we randomly calculate a list of 10 percent of all the
items for every quarter.

DNA

Do you mean random items or for ALL items? Maybe I'm misunderstanding.

ysymon

Yes, calculating 10 percentage randomly every quarter.

"DNA" wrote:

Do you mean random items or for ALL items? Maybe I'm misunderstanding.

All times are GMT +1. The time now is 04:20 AM.