S
skimpw
i work with a local charity and we sell 1000 calendars per year and hol
a raffle.
here's how the raffle works
on the first day of the month we want to select 31,30 or 28(based o
days of the preceding month) names from a list of individuals wh
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 b
using the add in sample
column f1:e31,30 or 28 is the days of the preceding month (differen
amounts are given for different days)
here's my question i want to match the colunm e the winning number
selected by sample with column a1 and place column f next to tha
number so i can sort the winners by days. as of now iam having t
manually place this info in a column i create
a raffle.
here's how the raffle works
on the first day of the month we want to select 31,30 or 28(based o
days of the preceding month) names from a list of individuals wh
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 b
using the add in sample
column f1:e31,30 or 28 is the days of the preceding month (differen
amounts are given for different days)
here's my question i want to match the colunm e the winning number
selected by sample with column a1 and place column f next to tha
number so i can sort the winners by days. as of now iam having t
manually place this info in a column i create