random sample
 

i work with a local charity and we sell 1000 calendars per year and hold
a raffle.
here's how the raffle works
on the first day of the month we want to select 31,30 or 28(based on
days of the preceding month) names from a list of individuals who
purchased the calendars.
the work sheet looks like so
column a1:a1000 calendar numbers 1 to 1000
column b1:b1000 name and address of calendar purchases.
column e1:e31,30 or 28 is the calendar number winners as picked by
using the add in sample
column f1:e31,30 or 28 is the days of the preceding month (different
amounts are given for different days)
here's my question i want to match the colunm e the winning numbers
selected by sample with column a1 and place column f next to that
number so i can sort the winners by days. as of now iam having to
manually place this info in a column i created


--
skimpw
------------------------------------------------------------------------
skimpw's Profile: http://www.excelforum.com/member.php...o&userid=37480
View this thread: http://www.excelforum.com/showthread...hreadid=571622