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