Sorting lists [closed]

asked 2012-12-28 19:17:48 +0200

muellm gravatar image

updated 2015-11-02 04:03:38 +0200

Alex Kemp gravatar image

On Sheet 1, I have a list of items, 125 items, each with a probability of appearing. I want sheet 2 to be a generated list of items based on Sheet 1. It checks each item in Sheet 1, randomly determines if it's present based on the listed probability, and then lists it if is present. What formulas would do this?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-04-14 03:21:13.674186

Comments

1

Data - Pivot Table? COUNTIF(), LARGE(), RANK() ? RANDBETWEEN()? Without sample data and an example of the desired result very difficult to answer this question.

JohnSUN gravatar imageJohnSUN ( 2012-12-28 20:23:45 +0200 )edit