how to select every fourth name from a list of voters

  • Thread starter Thread starter chowmich
  • Start date Start date
C

chowmich

I have a list of voters and I want to send a survey to every fourth nam
on the list

TI
 
For those to whose workbooks the functions in the freely downloadable
file at http://home.pacbell.net/beban are available:

ArrayAlternates(ArrayAlternates(list_range)) will return an array of the
1st, 5th, 9th. . . names.

ArrayAlternates(ArrayAlternates(list_range,False),False) will return an
array of the 4th, 8th, 12th. . . .

Alan Beban
 
My list begins in A1. In B1 enter =IF(MOD(ROW(),4)=0,A1," "). Copy down the
column.
Every fourth name shows in column B
Select the data in B; use Copy; open a new sheet or workbook; use Edit|Paste
Special ->Values. Now Sort the list to get rid to the blanks - any anyone
who votes Tory
 
Back
Top