filter a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

L.J. - 29 Jun 2004 22:50 GMT

Hi all,

In the "City" column, we type city with capital case in order to identify
the donors. Now I need to mass mailing to the donors only. Is there any
possibilty that I can filter all cities typed with "cpital case"?

Thanks in advance for your help!

Regards,
L.J

Reply to this Message

Debra Dalgleish - 29 Jun 2004 23:11 GMT

Add a new column to the table, with the heading "Donor"
In the cell below the heading, enter the formula:
=EXACT(D2,UPPER(D2))
where city is in column D
Copy the formula down to the last row of data
Filter the table for TRUE in the Donor column.

> In the "City" column, we type city with capital case in order to identify
> the donors. Now I need to mass mailing to the donors only. Is there any
> possibilty that I can filter all cities typed with "cpital case"?

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

L.J. - 30 Jun 2004 01:17 GMT

Dear Dalgleish,

Thanks so much for the prompt reply. You are awesome.

Regards,
L.J

> Add a new column to the table, with the heading "Donor"
> In the cell below the heading, enter the formula:
[quoted text clipped - 6 lines]
> > the donors. Now I need to mass mailing to the donors only. Is there any
> > possibilty that I can filter all cities typed with "cpital case"?

Reply to this Message