r/excel•
jidewalker

Having trouble writing formula to get 5% of data

unsolved

Hi,

I currently have an excel with many different data points. Its cases worked by a group of people. I would like to get a random 5% of the cases worked for each person so I could then send those cases to get audited. Would you happen to know the easiest way of writing this formula?

Thanks in Advance.

Posted Oct 6, 2025, 7:17 PM UTC

34
Loading comments…