Create Formula to randomly Sequence/Prioritize a list of items

[stephenw1978]

I hope someone can help with creating a formula to help automate a manual process of taking a list and organizing it into a list showing 3 items. I have between 3 and 10 items that need to be filtered so that at any given time only 3 items are included. Eg. Apple, Pear, Grapes and Orange. It's pretty straightforward when I only have 3 items, but when I have multiple to number of results increases significantly. Please see my enclosed workbook example, and what you so much for any help.

 

[dreid1011]

What version of Excel are you using? You should update your profile to show this so we know what solutions to provide or not.

 

[stephenw1978]

What version of Excel are you using? You should update your profile to show this so we know what solutions to provide or not.

Hi, I usually work in Google sheets, but the excel I use is version 16.8.
Thank you

 

[dreid1011]

Hi, I usually work in Google sheets, but the excel I use is version 16.8.
Thank you

Well, I was able to work up a solution for Excel 365, but I am not familiar with Google Sheets and not handy enough with the older functions to make it work on 16.8, as it looks like that is from 2017.