View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_118_] Mike[_118_] is offline
external usenet poster
 
Posts: 2
Default random sampling TEXT

Hi

Let's say if there are 24 peoples with their IDs as following:

1 A
2 B
3 c
4 d
5 e
6 f
7 g
8 h
9 i
10 j
11 k
12 l
13 m
14 n
15 o
16 p
17 q
18 r
19 s
20 t
21 u
22 v
23 w
24 x

If I want to randomly sample 5 people with their IDs and names,
how do I do it?
I've tested it. I can have five random IDs, but cannot have their
corresponding names.

thank you in advance.

Mike