Hi again, I am wondering if there is any formula to draw a random sample of fixed size in excel.

Let say, In the 1st column I have a list of City-names of length 100. Now I want to draw a Random-sample of Cities of size 10 out of 100. All 100 cities have equal probability to get selected in my sample of size 10. What is the way for doing this.

Really appreciate for your pointer.

Thanks,