If you sort the items in ascending order by their price, you could use something like this:
=INDEX(B2:B18,RANDBETWEEN(2,MATCH(G1,C2:C18,1)),1)
G1 being where i put the price
If you sort the items in ascending order by their price, you could use something like this:
=INDEX(B2:B18,RANDBETWEEN(2,MATCH(G1,C2:C18,1)),1)
G1 being where i put the price
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks