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