Help

[Snehal]

I have an excel database of people with their names and addresses. We want to send a letter to each family, so I need to somehow find a function of getting multiple addresses to one ie I have a column of addresses in which there may be a family of 4 followed by a family of 3 then a family of 4 etc, but I need to send the letter to only one family member from each of the families. How do I do this ??

 

[Yogi Anand]

Hi Snehal:

Here we go ...

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M
1													source
2								TRUE	TRUE	TRUE			criteria
3													copyto
4
5	ID	LastName	FirstName	Address	City	PostalCode		ID	LastName	FirstName	Address	City	PostalCode
6	0001	Jones	Alan	88RobertRd	Sydney	2000		0001	Jones	Alan	88RobertRd	Sydney	2000
7	0012	Jones	Stan	88RobertRd	Sydney	2000		0007	Smith	Alex	10DarlAve	NorthSydney	2001
8	0007	Smith	Alex	10DarlAve	NorthSydney	2001
9	0007	Smith	Lisa	10DarlAve	NorthSydney	2001
Sheet1

I have used AdvancedFilter.

The formula in cell H2 is ... =COUNTIF($D$6:D6,D6)=1
the formula in cell I2 is ... =COUNTIF($E$6:E6,E6)=1
and formula in cell J2 is ... =COUNTIF($F$6:F6,F6)=1

 

[Snehal]

Yogi

Thanks for your help....it seems to have worked. I will get back to you if I have any more queries.


Thanks Again for all your help.

Snehal