Hi all, hope you're well.

I've been using the randbetween function to pick a random name from a list (thousands of names in the list).

I'm looking to take it a step further though.

For example:

Return a random name from the list, but only from names in the list that begin with the letter S.

Would there be a way to use the LEFT or MID functions with RANDBETWEEN to do this?

So it would essentially find the letter S in the list, and return a random name from the list beginning with S.

I hope this makes sense?

Would appreciate any input,

Thanks
Steve