I am trying to use the "Advanced filter" to extract data and copy it to the
extract area of my spreadsheet. I have my criteria area & my extract area in
place, but am uncertain how to pull all last names that begin with one
specific letter. I have tried a couple of different functions in the
critereia field, but can't get the result I'm looking for. Can anyone help me
on this? Thanks!

In the criteria area, use the same heading as in the Last Name field in
your table.
In the cell below, type a letter and asterisk, e.g.: A*
When you run the Advanced filter, select both cells for the criteria area.

Lisa wrote:
I am trying to use the "Advanced filter" to extract data and copy it to the
extract area of my spreadsheet. I have my criteria area & my extract area in
place, but am uncertain how to pull all last names that begin with one
specific letter. I have tried a couple of different functions in the
critereia field, but can't get the result I'm looking for. Can anyone help me
on this? Thanks!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thank you, it worked. I was overcomplicating this one!

"Debra Dalgleish" wrote:

In the criteria area, use the same heading as in the Last Name field in
your table.
In the cell below, type a letter and asterisk, e.g.: A*
When you run the Advanced filter, select both cells for the criteria area.

Lisa wrote:
I am trying to use the "Advanced filter" to extract data and copy it to the
extract area of my spreadsheet. I have my criteria area & my extract area in
place, but am uncertain how to pull all last names that begin with one
specific letter. I have tried a couple of different functions in the
critereia field, but can't get the result I'm looking for. Can anyone help me
on this? Thanks!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html