How do I easily divide an excel list of names/addresses among 6 pe
Assuming that you have your various data in seperate columns etc
I also assume that the data is in *date* order
You want to divided the list into 6 so that the first 6 weddings are given
1 each to the 6 people, then the next 6 to those same 6 etc etc.
Add an extra column of data with the values 1,2,3,4,5,6 repeated
The data an then be viewed via the data filter to show just one persion,
ie no 4
or by sorting on the person number first, then the date
you will have 6 *lists*
Exact details depened on the format of your data etc, but that's the idea
Steve
On Wed, 13 Sep 2006 07:55:02 +0100, MGrantvine
wrote:
I am very new to Excel and need to divide an excel spreadsheet with 250
names, addresses, dates, etc between 6 people in an order of wedding
date.
Is there a really easy way to divide the list up so that each of the 6
people gets the next name on the list?
--
Steve (3)
|