I am trying to use the Excel SAMPLING function to get a sample of 30 UNIQUE ID'S from a pool of 100 different ID's. When I use the function I am getting duplicates of several numbers, when it should be pulling 30 unique ID's from the 100 I have selected.

I have inserted the problem below- The column to the far right is the result I am getting when running the function and you can see there are about 4 duplicates in it. How do you run that function without getting any duplicates?

Management IDs			117
237	744	669	87	964	630	356	577	715	31			900
214	939	222	26	206	802	769	807	408	103			803
151	391	536	473	340	206	480	339	257	595			711
284	420	787	919	117	898	610	343	282	104			420
31	649	711	458	236	452	330	178	844	875			888
226	614	159	578	679	934	16	206	405	326			844
512	900	212	975	795	806	561	605	978	899			391
956	600	88	430	342	122	394	107	84	252			391
124	496	617	573	198	499	803	610	189	61			600
483	42	971	87	287	232	888	391	122	483			964
												84
You planning to conduct a study involving leadership acumen within the medical center. You need a random sample of 30 management officials employed at XYZ Medical Center. You'll use the SAMPLING function within Microsoft Excel for task.							16
						206
						236
						16
						578
												232
Now that you have determined the answer, it is time to provide a brief write-up										971
of your output. In statistics, it is important that you not only get the correct										795
mathematical answer, but that you become comfortable writing up your results in										744
a manner that is easily understood by the reader/audience.										744
												573
The Sampling function in Excel will give you a sample size of your choosing within a chosen range of data. For this question 30 Management IDs were needed out of a sample size of 100.						430
					206
					610
					330
					458
					483
												561