how to select every fourth name from a list of voters

C

chowmich

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

TI
 
A

Alan Beban

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

merging two worksheets 3
limiting distinct to above threshold 0
Insert name and adress from a list in a word document 1
Weekly Report 2
Cross-Referencing Lists 2
How to make repeating drop-down lists? 2
VBA Coding Help for Beginner 0
Space at end of multi page list to accommodate new entries 1

Top