software

My customer base of 5,000 records (columns a-l) has some invalid email
addresses in column g. The quot;@quot; is missing. I would like to have those
particular email addresses sorted at the beginning of the list so that I can
go through them and see if they can be corrected or deleted.

Which formula would work best for this project?

Thanks for your help.

Best regards,
victortry data filter
datagt;filtergt;autofiltergt;customgt;doesnotcontain @

--
Don Guillett
SalesAid Software

quot;la90292quot; gt; wrote in message ...
gt; My customer base of 5,000 records (columns a-l) has some invalid email
gt; addresses in column g. The quot;@quot; is missing. I would like to have those
gt; particular email addresses sorted at the beginning of the list so that I
gt; can
gt; go through them and see if they can be corrected or deleted.
gt;
gt; Which formula would work best for this project?
gt;
gt; Thanks for your help.
gt;
gt; Best regards,
gt; victor
gt;
gt;
gt;
gt;
Hi Don:

Thank's for the suggestion. That worked fine; however, my customer list has
been previously sorted using an quot;advanced filterquot; for the 13 western states
only. So, when I use your suggestion to identify the invalid email address
it shows all the records in all the states. How would I override this to
only do the customers in the 13 western states with invalid email addresses?

Thanks again for your time and consideration.

Best regards,
victor

quot;Don Guillettquot; gt; wrote in message
...
gt; try data filter
gt; datagt;filtergt;autofiltergt;customgt;doesnotcontain @
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;la90292quot; gt; wrote in message
gt; ...
gt;gt; My customer base of 5,000 records (columns a-l) has some invalid email
gt;gt; addresses in column g. The quot;@quot; is missing. I would like to have those
gt;gt; particular email addresses sorted at the beginning of the list so that I
gt;gt; can
gt;gt; go through them and see if they can be corrected or deleted.
gt;gt;
gt;gt; Which formula would work best for this project?
gt;gt;
gt;gt; Thanks for your help.
gt;gt;
gt;gt; Best regards,
gt;gt; victor
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Couldn't you apply both filters?

--
Don Guillett
SalesAid Software

quot;SeaTigerquot; gt; wrote in message
. com...
gt; Hi Don:
gt;
gt; Thank's for the suggestion. That worked fine; however, my customer list
gt; has been previously sorted using an quot;advanced filterquot; for the 13 western
gt; states only. So, when I use your suggestion to identify the invalid email
gt; address it shows all the records in all the states. How would I override
gt; this to only do the customers in the 13 western states with invalid email
gt; addresses?
gt;
gt; Thanks again for your time and consideration.
gt;
gt; Best regards,
gt; victor
gt;
gt; quot;Don Guillettquot; gt; wrote in message
gt; ...
gt;gt; try data filter
gt;gt; datagt;filtergt;autofiltergt;customgt;doesnotcontain @
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;la90292quot; gt; wrote in message
gt;gt; ...
gt;gt;gt; My customer base of 5,000 records (columns a-l) has some invalid email
gt;gt;gt; addresses in column g. The quot;@quot; is missing. I would like to have those
gt;gt;gt; particular email addresses sorted at the beginning of the list so that I
gt;gt;gt; can
gt;gt;gt; go through them and see if they can be corrected or deleted.
gt;gt;gt;
gt;gt;gt; Which formula would work best for this project?
gt;gt;gt;
gt;gt;gt; Thanks for your help.
gt;gt;gt;
gt;gt;gt; Best regards,
gt;gt;gt; victor
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Since one is an advanced filter and one an auto filter how can you apply
them at the same time. I can not do them separately without showing all the
records again. Or, how would I use write the formula above the email column
using the advanced filter to produce the same results as the auto filter. I
tried writing quot;does not contain @quot; above the email colum, but that didn't
work.

Best regards,
victor

Don Guillett gt; wrote in message
...
gt; Couldn't you apply both filters?
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;SeaTigerquot; gt; wrote in message
gt; . com...
gt; gt; Hi Don:
gt; gt;
gt; gt; Thank's for the suggestion. That worked fine; however, my customer list
gt; gt; has been previously sorted using an quot;advanced filterquot; for the 13 western
gt; gt; states only. So, when I use your suggestion to identify the invalid
email
gt; gt; address it shows all the records in all the states. How would I override
gt; gt; this to only do the customers in the 13 western states with invalid
email
gt; gt; addresses?
gt; gt;
gt; gt; Thanks again for your time and consideration.
gt; gt;
gt; gt; Best regards,
gt; gt; victor
gt; gt;
gt; gt; quot;Don Guillettquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; try data filter
gt; gt;gt; datagt;filtergt;autofiltergt;customgt;doesnotcontain @
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Don Guillett
gt; gt;gt; SalesAid Software
gt; gt;gt;
gt; gt;gt; quot;la90292quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt;gt; My customer base of 5,000 records (columns a-l) has some invalid
email
gt; gt;gt;gt; addresses in column g. The quot;@quot; is missing. I would like to have those
gt; gt;gt;gt; particular email addresses sorted at the beginning of the list so that
I
gt; gt;gt;gt; can
gt; gt;gt;gt; go through them and see if they can be corrected or deleted.
gt; gt;gt;gt;
gt; gt;gt;gt; Which formula would work best for this project?
gt; gt;gt;gt;
gt; gt;gt;gt; Thanks for your help.
gt; gt;gt;gt;
gt; gt;gt;gt; Best regards,
gt; gt;gt;gt; victor
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
Another suggestion would be to use advanced filter and copy to another
location, that would give you
an unfiltered list separated from the original list and you can apply
autofilter on that list

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;la90292quot; gt; wrote in message
. com...
gt; Since one is an advanced filter and one an auto filter how can you apply
gt; them at the same time. I can not do them separately without showing all
gt; the
gt; records again. Or, how would I use write the formula above the email
gt; column
gt; using the advanced filter to produce the same results as the auto filter.
gt; I
gt; tried writing quot;does not contain @quot; above the email colum, but that didn't
gt; work.
gt;
gt; Best regards,
gt; victor
gt;
gt; Don Guillett gt; wrote in message
gt; ...
gt;gt; Couldn't you apply both filters?
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;SeaTigerquot; gt; wrote in message
gt;gt; . com...
gt;gt; gt; Hi Don:
gt;gt; gt;
gt;gt; gt; Thank's for the suggestion. That worked fine; however, my customer list
gt;gt; gt; has been previously sorted using an quot;advanced filterquot; for the 13
gt;gt; gt; western
gt;gt; gt; states only. So, when I use your suggestion to identify the invalid
gt; email
gt;gt; gt; address it shows all the records in all the states. How would I
gt;gt; gt; override
gt;gt; gt; this to only do the customers in the 13 western states with invalid
gt; email
gt;gt; gt; addresses?
gt;gt; gt;
gt;gt; gt; Thanks again for your time and consideration.
gt;gt; gt;
gt;gt; gt; Best regards,
gt;gt; gt; victor
gt;gt; gt;
gt;gt; gt; quot;Don Guillettquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; try data filter
gt;gt; gt;gt; datagt;filtergt;autofiltergt;customgt;doesnotcontain @
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Don Guillett
gt;gt; gt;gt; SalesAid Software
gt;gt; gt;gt;
gt;gt; gt;gt; quot;la90292quot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt;gt; My customer base of 5,000 records (columns a-l) has some invalid
gt; email
gt;gt; gt;gt;gt; addresses in column g. The quot;@quot; is missing. I would like to have those
gt;gt; gt;gt;gt; particular email addresses sorted at the beginning of the list so
gt;gt; gt;gt;gt; that
gt; I
gt;gt; gt;gt;gt; can
gt;gt; gt;gt;gt; go through them and see if they can be corrected or deleted.
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt; Which formula would work best for this project?
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt; Thanks for your help.
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt; Best regards,
gt;gt; gt;gt;gt; victor
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;Hi Peo:

That's what I did, but when I attempted to do the auto filter the previous
records come up again. What do I need to do to the new list so that doesn't
happen.

Thanks, victor

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; Another suggestion would be to use advanced filter and copy to another
gt; location, that would give you
gt; an unfiltered list separated from the original list and you can apply
gt; autofilter on that list
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;la90292quot; gt; wrote in message
gt; . com...
gt;gt; Since one is an advanced filter and one an auto filter how can you apply
gt;gt; them at the same time. I can not do them separately without showing all
gt;gt; the
gt;gt; records again. Or, how would I use write the formula above the email
gt;gt; column
gt;gt; using the advanced filter to produce the same results as the auto filter.
gt;gt; I
gt;gt; tried writing quot;does not contain @quot; above the email colum, but that didn't
gt;gt; work.
gt;gt;
gt;gt; Best regards,
gt;gt; victor
gt;gt;
gt;gt; Don Guillett gt; wrote in message
gt;gt; ...
gt;gt;gt; Couldn't you apply both filters?
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Don Guillett
gt;gt;gt; SalesAid Software
gt;gt;gt;
gt;gt;gt; quot;SeaTigerquot; gt; wrote in message
gt;gt;gt; . com...
gt;gt;gt; gt; Hi Don:
gt;gt;gt; gt;
gt;gt;gt; gt; Thank's for the suggestion. That worked fine; however, my customer
gt;gt;gt; gt; list
gt;gt;gt; gt; has been previously sorted using an quot;advanced filterquot; for the 13
gt;gt;gt; gt; western
gt;gt;gt; gt; states only. So, when I use your suggestion to identify the invalid
gt;gt; email
gt;gt;gt; gt; address it shows all the records in all the states. How would I
gt;gt;gt; gt; override
gt;gt;gt; gt; this to only do the customers in the 13 western states with invalid
gt;gt; email
gt;gt;gt; gt; addresses?
gt;gt;gt; gt;
gt;gt;gt; gt; Thanks again for your time and consideration.
gt;gt;gt; gt;
gt;gt;gt; gt; Best regards,
gt;gt;gt; gt; victor
gt;gt;gt; gt;
gt;gt;gt; gt; quot;Don Guillettquot; gt; wrote in message
gt;gt;gt; gt; ...
gt;gt;gt; gt;gt; try data filter
gt;gt;gt; gt;gt; datagt;filtergt;autofiltergt;customgt;doesnotcontain @
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; --
gt;gt;gt; gt;gt; Don Guillett
gt;gt;gt; gt;gt; SalesAid Software
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; quot;la90292quot; gt; wrote in message
gt;gt;gt; gt;gt; ...
gt;gt;gt; gt;gt;gt; My customer base of 5,000 records (columns a-l) has some invalid
gt;gt; email
gt;gt;gt; gt;gt;gt; addresses in column g. The quot;@quot; is missing. I would like to have
gt;gt;gt; gt;gt;gt; those
gt;gt;gt; gt;gt;gt; particular email addresses sorted at the beginning of the list so
gt;gt;gt; gt;gt;gt; that
gt;gt; I
gt;gt;gt; gt;gt;gt; can
gt;gt;gt; gt;gt;gt; go through them and see if they can be corrected or deleted.
gt;gt;gt; gt;gt;gt;
gt;gt;gt; gt;gt;gt; Which formula would work best for this project?
gt;gt;gt; gt;gt;gt;
gt;gt;gt; gt;gt;gt; Thanks for your help.
gt;gt;gt; gt;gt;gt;
gt;gt;gt; gt;gt;gt; Best regards,
gt;gt;gt; gt;gt;gt; victor
gt;gt;gt; gt;gt;gt;
gt;gt;gt; gt;gt;gt;
gt;gt;gt; gt;gt;gt;
gt;gt;gt; gt;gt;gt;
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt;
gt;gt;gt; gt;
gt;gt;gt; gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
I would copy the advanced filtered list to another sheet, thus out of the
way form any filters on the same sheet
If you start from the sheet where you want to copy the list, assume the list
is in Sheet1 and you want to filtered list in Sheet2,
click in A1 in Sheet2, do datagt;filtergt;advanced filter, click in the list
range and select the table in Sheet1,
put in the criteria, then copy to click in a cell in Sheet2, do then filter
and it will be in Sheet2, now you will have a filtered list without any
interference, then apply the autofilter and filter 'til the cows come home--
Regards,

Peo Sjoblom

Portland, Oregon

quot;SeaTigerquot; gt; wrote in message
. ..
gt; Hi Peo:
gt;
gt; That's what I did, but when I attempted to do the auto filter the previous
gt; records come up again. What do I need to do to the new list so that
gt; doesn't happen.
gt;
gt; Thanks, victor
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; ...
gt;gt; Another suggestion would be to use advanced filter and copy to another
gt;gt; location, that would give you
gt;gt; an unfiltered list separated from the original list and you can apply
gt;gt; autofilter on that list
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;la90292quot; gt; wrote in message
gt;gt; . com...
gt;gt;gt; Since one is an advanced filter and one an auto filter how can you apply
gt;gt;gt; them at the same time. I can not do them separately without showing all
gt;gt;gt; the
gt;gt;gt; records again. Or, how would I use write the formula above the email
gt;gt;gt; column
gt;gt;gt; using the advanced filter to produce the same results as the auto
gt;gt;gt; filter. I
gt;gt;gt; tried writing quot;does not contain @quot; above the email colum, but that
gt;gt;gt; didn't
gt;gt;gt; work.
gt;gt;gt;
gt;gt;gt; Best regards,
gt;gt;gt; victor
gt;gt;gt;
gt;gt;gt; Don Guillett gt; wrote in message
gt;gt;gt; ...
gt;gt;gt;gt; Couldn't you apply both filters?
gt;gt;gt;gt;
gt;gt;gt;gt; --
gt;gt;gt;gt; Don Guillett
gt;gt;gt;gt; SalesAid Software
gt;gt;gt;gt;
gt;gt;gt;gt; quot;SeaTigerquot; gt; wrote in message
gt;gt;gt;gt; . com...
gt;gt;gt;gt; gt; Hi Don:
gt;gt;gt;gt; gt;
gt;gt;gt;gt; gt; Thank's for the suggestion. That worked fine; however, my customer
gt;gt;gt;gt; gt; list
gt;gt;gt;gt; gt; has been previously sorted using an quot;advanced filterquot; for the 13
gt;gt;gt;gt; gt; western
gt;gt;gt;gt; gt; states only. So, when I use your suggestion to identify the invalid
gt;gt;gt; email
gt;gt;gt;gt; gt; address it shows all the records in all the states. How would I
gt;gt;gt;gt; gt; override
gt;gt;gt;gt; gt; this to only do the customers in the 13 western states with invalid
gt;gt;gt; email
gt;gt;gt;gt; gt; addresses?
gt;gt;gt;gt; gt;
gt;gt;gt;gt; gt; Thanks again for your time and consideration.
gt;gt;gt;gt; gt;
gt;gt;gt;gt; gt; Best regards,
gt;gt;gt;gt; gt; victor
gt;gt;gt;gt; gt;
gt;gt;gt;gt; gt; quot;Don Guillettquot; gt; wrote in message
gt;gt;gt;gt; gt; ...
gt;gt;gt;gt; gt;gt; try data filter
gt;gt;gt;gt; gt;gt; datagt;filtergt;autofiltergt;customgt;doesnotcontain @
gt;gt;gt;gt; gt;gt;
gt;gt;gt;gt; gt;gt; --
gt;gt;gt;gt; gt;gt; Don Guillett
gt;gt;gt;gt; gt;gt; SalesAid Software
gt;gt;gt;gt; gt;gt;
gt;gt;gt;gt; gt;gt; quot;la90292quot; gt; wrote in message
gt;gt;gt;gt; gt;gt; ...
gt;gt;gt;gt; gt;gt;gt; My customer base of 5,000 records (columns a-l) has some invalid
gt;gt;gt; email
gt;gt;gt;gt; gt;gt;gt; addresses in column g. The quot;@quot; is missing. I would like to have
gt;gt;gt;gt; gt;gt;gt; those
gt;gt;gt;gt; gt;gt;gt; particular email addresses sorted at the beginning of the list so
gt;gt;gt;gt; gt;gt;gt; that
gt;gt;gt; I
gt;gt;gt;gt; gt;gt;gt; can
gt;gt;gt;gt; gt;gt;gt; go through them and see if they can be corrected or deleted.
gt;gt;gt;gt; gt;gt;gt;
gt;gt;gt;gt; gt;gt;gt; Which formula would work best for this project?
gt;gt;gt;gt; gt;gt;gt;
gt;gt;gt;gt; gt;gt;gt; Thanks for your help.
gt;gt;gt;gt; gt;gt;gt;
gt;gt;gt;gt; gt;gt;gt; Best regards,
gt;gt;gt;gt; gt;gt;gt; victor
gt;gt;gt;gt; gt;gt;gt;
gt;gt;gt;gt; gt;gt;gt;
gt;gt;gt;gt; gt;gt;gt;
gt;gt;gt;gt; gt;gt;gt;
gt;gt;gt;gt; gt;gt;
gt;gt;gt;gt; gt;gt;
gt;gt;gt;gt; gt;
gt;gt;gt;gt; gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;
gt;Okay, that worked. It took awhile because you have to make sure you have the
right sheets before each range and criteria so I kept getting error
messages.

Now I'm ready to bring the cows home and want to auto filter my email
addresses to identify those cells that are not blank and do not have the @.
I figured out the quot;does not containquot; @, but what do I use for the
identifying the records that are not blank??

Really, thanks alot for your help.

Best regards,
victorMy customer list is file is in sheet 2. My list range is : $A$15:$l$5443. My
criteria range is: $A$1:$l$14.

Peo Sjoblom gt; wrote in message
...
gt; I would copy the advanced filtered list to another sheet, thus out of the
gt; way form any filters on the same sheet
gt; If you start from the sheet where you want to copy the list, assume the
list
gt; is in Sheet1 and you want to filtered list in Sheet2,
gt; click in A1 in Sheet2, do datagt;filtergt;advanced filter, click in the list
gt; range and select the table in Sheet1,
gt; put in the criteria, then copy to click in a cell in Sheet2, do then
filter
gt; and it will be in Sheet2, now you will have a filtered list without any
gt; interference, then apply the autofilter and filter 'til the cows come home
gt;
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;SeaTigerquot; gt; wrote in message
gt; . ..
gt; gt; Hi Peo:
gt; gt;
gt; gt; That's what I did, but when I attempted to do the auto filter the
previous
gt; gt; records come up again. What do I need to do to the new list so that
gt; gt; doesn't happen.
gt; gt;
gt; gt; Thanks, victor
gt; gt;
gt; gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Another suggestion would be to use advanced filter and copy to another
gt; gt;gt; location, that would give you
gt; gt;gt; an unfiltered list separated from the original list and you can apply
gt; gt;gt; autofilter on that list
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; Portland, Oregon
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;la90292quot; gt; wrote in message
gt; gt;gt; . com...
gt; gt;gt;gt; Since one is an advanced filter and one an auto filter how can you
apply
gt; gt;gt;gt; them at the same time. I can not do them separately without showing
all
gt; gt;gt;gt; the
gt; gt;gt;gt; records again. Or, how would I use write the formula above the email
gt; gt;gt;gt; column
gt; gt;gt;gt; using the advanced filter to produce the same results as the auto
gt; gt;gt;gt; filter. I
gt; gt;gt;gt; tried writing quot;does not contain @quot; above the email colum, but that
gt; gt;gt;gt; didn't
gt; gt;gt;gt; work.
gt; gt;gt;gt;
gt; gt;gt;gt; Best regards,
gt; gt;gt;gt; victor
gt; gt;gt;gt;
gt; gt;gt;gt; Don Guillett gt; wrote in message
gt; gt;gt;gt; ...
gt; gt;gt;gt;gt; Couldn't you apply both filters?
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt; --
gt; gt;gt;gt;gt; Don Guillett
gt; gt;gt;gt;gt; SalesAid Software
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt; quot;SeaTigerquot; gt; wrote in message
gt; gt;gt;gt;gt; . com...
gt; gt;gt;gt;gt; gt; Hi Don:
gt; gt;gt;gt;gt; gt;
gt; gt;gt;gt;gt; gt; Thank's for the suggestion. That worked fine; however, my customer
gt; gt;gt;gt;gt; gt; list
gt; gt;gt;gt;gt; gt; has been previously sorted using an quot;advanced filterquot; for the 13
gt; gt;gt;gt;gt; gt; western
gt; gt;gt;gt;gt; gt; states only. So, when I use your suggestion to identify the invalid
gt; gt;gt;gt; email
gt; gt;gt;gt;gt; gt; address it shows all the records in all the states. How would I
gt; gt;gt;gt;gt; gt; override
gt; gt;gt;gt;gt; gt; this to only do the customers in the 13 western states with invalid
gt; gt;gt;gt; email
gt; gt;gt;gt;gt; gt; addresses?
gt; gt;gt;gt;gt; gt;
gt; gt;gt;gt;gt; gt; Thanks again for your time and consideration.
gt; gt;gt;gt;gt; gt;
gt; gt;gt;gt;gt; gt; Best regards,
gt; gt;gt;gt;gt; gt; victor
gt; gt;gt;gt;gt; gt;
gt; gt;gt;gt;gt; gt; quot;Don Guillettquot; gt; wrote in message
gt; gt;gt;gt;gt; gt; ...
gt; gt;gt;gt;gt; gt;gt; try data filter
gt; gt;gt;gt;gt; gt;gt; datagt;filtergt;autofiltergt;customgt;doesnotcontain @
gt; gt;gt;gt;gt; gt;gt;
gt; gt;gt;gt;gt; gt;gt; --
gt; gt;gt;gt;gt; gt;gt; Don Guillett
gt; gt;gt;gt;gt; gt;gt; SalesAid Software
gt; gt;gt;gt;gt; gt;gt;
gt; gt;gt;gt;gt; gt;gt; quot;la90292quot; gt; wrote in message
gt; gt;gt;gt;gt; gt;gt; ...
gt; gt;gt;gt;gt; gt;gt;gt; My customer base of 5,000 records (columns a-l) has some invalid
gt; gt;gt;gt; email
gt; gt;gt;gt;gt; gt;gt;gt; addresses in column g. The quot;@quot; is missing. I would like to have
gt; gt;gt;gt;gt; gt;gt;gt; those
gt; gt;gt;gt;gt; gt;gt;gt; particular email addresses sorted at the beginning of the list so
gt; gt;gt;gt;gt; gt;gt;gt; that
gt; gt;gt;gt; I
gt; gt;gt;gt;gt; gt;gt;gt; can
gt; gt;gt;gt;gt; gt;gt;gt; go through them and see if they can be corrected or deleted.
gt; gt;gt;gt;gt; gt;gt;gt;
gt; gt;gt;gt;gt; gt;gt;gt; Which formula would work best for this project?
gt; gt;gt;gt;gt; gt;gt;gt;
gt; gt;gt;gt;gt; gt;gt;gt; Thanks for your help.
gt; gt;gt;gt;gt; gt;gt;gt;
gt; gt;gt;gt;gt; gt;gt;gt; Best regards,
gt; gt;gt;gt;gt; gt;gt;gt; victor
gt; gt;gt;gt;gt; gt;gt;gt;
gt; gt;gt;gt;gt; gt;gt;gt;
gt; gt;gt;gt;gt; gt;gt;gt;
gt; gt;gt;gt;gt; gt;gt;gt;
gt; gt;gt;gt;gt; gt;gt;
gt; gt;gt;gt;gt; gt;gt;
gt; gt;gt;gt;gt; gt;
gt; gt;gt;gt;gt; gt;
gt; gt;gt;gt;gt;
gt; gt;gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
OK, from autofilter dropdown select custom, then does not contain @
AND does not equal and leave the box to the right empty

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;la90292quot; gt; wrote in message
. com...
gt; Okay, that worked. It took awhile because you have to make sure you have
gt; the
gt; right sheets before each range and criteria so I kept getting error
gt; messages.
gt;
gt; Now I'm ready to bring the cows home and want to auto filter my email
gt; addresses to identify those cells that are not blank and do not have the
gt; @.
gt; I figured out the quot;does not containquot; @, but what do I use for the
gt; identifying the records that are not blank??
gt;
gt; Really, thanks alot for your help.
gt;
gt; Best regards,
gt; victor
gt;
gt;
gt; My customer list is file is in sheet 2. My list range is : $A$15:$l$5443.
gt; My
gt; criteria range is: $A$1:$l$14.
gt;
gt; Peo Sjoblom gt; wrote in message
gt; ...
gt;gt; I would copy the advanced filtered list to another sheet, thus out of the
gt;gt; way form any filters on the same sheet
gt;gt; If you start from the sheet where you want to copy the list, assume the
gt; list
gt;gt; is in Sheet1 and you want to filtered list in Sheet2,
gt;gt; click in A1 in Sheet2, do datagt;filtergt;advanced filter, click in the list
gt;gt; range and select the table in Sheet1,
gt;gt; put in the criteria, then copy to click in a cell in Sheet2, do then
gt; filter
gt;gt; and it will be in Sheet2, now you will have a filtered list without any
gt;gt; interference, then apply the autofilter and filter 'til the cows come
gt;gt; home
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;SeaTigerquot; gt; wrote in message
gt;gt; . ..
gt;gt; gt; Hi Peo:
gt;gt; gt;
gt;gt; gt; That's what I did, but when I attempted to do the auto filter the
gt; previous
gt;gt; gt; records come up again. What do I need to do to the new list so that
gt;gt; gt; doesn't happen.
gt;gt; gt;
gt;gt; gt; Thanks, victor
gt;gt; gt;
gt;gt; gt; quot;Peo Sjoblomquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; Another suggestion would be to use advanced filter and copy to another
gt;gt; gt;gt; location, that would give you
gt;gt; gt;gt; an unfiltered list separated from the original list and you can apply
gt;gt; gt;gt; autofilter on that list
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Regards,
gt;gt; gt;gt;
gt;gt; gt;gt; Peo Sjoblom
gt;gt; gt;gt;
gt;gt; gt;gt; Portland, Oregon
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;la90292quot; gt; wrote in message
gt;gt; gt;gt; . com...
gt;gt; gt;gt;gt; Since one is an advanced filter and one an auto filter how can you
gt; apply
gt;gt; gt;gt;gt; them at the same time. I can not do them separately without showing
gt; all
gt;gt; gt;gt;gt; the
gt;gt; gt;gt;gt; records again. Or, how would I use write the formula above the email
gt;gt; gt;gt;gt; column
gt;gt; gt;gt;gt; using the advanced filter to produce the same results as the auto
gt;gt; gt;gt;gt; filter. I
gt;gt; gt;gt;gt; tried writing quot;does not contain @quot; above the email colum, but that
gt;gt; gt;gt;gt; didn't
gt;gt; gt;gt;gt; work.
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt; Best regards,
gt;gt; gt;gt;gt; victor
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt; Don Guillett gt; wrote in message
gt;gt; gt;gt;gt; ...
gt;gt; gt;gt;gt;gt; Couldn't you apply both filters?
gt;gt; gt;gt;gt;gt;
gt;gt; gt;gt;gt;gt; --
gt;gt; gt;gt;gt;gt; Don Guillett
gt;gt; gt;gt;gt;gt; SalesAid Software
gt;gt; gt;gt;gt;gt;
gt;gt; gt;gt;gt;gt; quot;SeaTigerquot; gt; wrote in message
gt;gt; gt;gt;gt;gt; . com...
gt;gt; gt;gt;gt;gt; gt; Hi Don:
gt;gt; gt;gt;gt;gt; gt;
gt;gt; gt;gt;gt;gt; gt; Thank's for the suggestion. That worked fine; however, my customer
gt;gt; gt;gt;gt;gt; gt; list
gt;gt; gt;gt;gt;gt; gt; has been previously sorted using an quot;advanced filterquot; for the 13
gt;gt; gt;gt;gt;gt; gt; western
gt;gt; gt;gt;gt;gt; gt; states only. So, when I use your suggestion to identify the
gt;gt; gt;gt;gt;gt; gt; invalid
gt;gt; gt;gt;gt; email
gt;gt; gt;gt;gt;gt; gt; address it shows all the records in all the states. How would I
gt;gt; gt;gt;gt;gt; gt; override
gt;gt; gt;gt;gt;gt; gt; this to only do the customers in the 13 western states with
gt;gt; gt;gt;gt;gt; gt; invalid
gt;gt; gt;gt;gt; email
gt;gt; gt;gt;gt;gt; gt; addresses?
gt;gt; gt;gt;gt;gt; gt;
gt;gt; gt;gt;gt;gt; gt; Thanks again for your time and consideration.
gt;gt; gt;gt;gt;gt; gt;
gt;gt; gt;gt;gt;gt; gt; Best regards,
gt;gt; gt;gt;gt;gt; gt; victor
gt;gt; gt;gt;gt;gt; gt;
gt;gt; gt;gt;gt;gt; gt; quot;Don Guillettquot; gt; wrote in message
gt;gt; gt;gt;gt;gt; gt; ...
gt;gt; gt;gt;gt;gt; gt;gt; try data filter
gt;gt; gt;gt;gt;gt; gt;gt; datagt;filtergt;autofiltergt;customgt;doesnotcontain @
gt;gt; gt;gt;gt;gt; gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt; --
gt;gt; gt;gt;gt;gt; gt;gt; Don Guillett
gt;gt; gt;gt;gt;gt; gt;gt; SalesAid Software
gt;gt; gt;gt;gt;gt; gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt; quot;la90292quot; gt; wrote in message
gt;gt; gt;gt;gt;gt; gt;gt; ...
gt;gt; gt;gt;gt;gt; gt;gt;gt; My customer base of 5,000 records (columns a-l) has some
gt;gt; gt;gt;gt;gt; gt;gt;gt; invalid
gt;gt; gt;gt;gt; email
gt;gt; gt;gt;gt;gt; gt;gt;gt; addresses in column g. The quot;@quot; is missing. I would like to have
gt;gt; gt;gt;gt;gt; gt;gt;gt; those
gt;gt; gt;gt;gt;gt; gt;gt;gt; particular email addresses sorted at the beginning of the list
gt;gt; gt;gt;gt;gt; gt;gt;gt; so
gt;gt; gt;gt;gt;gt; gt;gt;gt; that
gt;gt; gt;gt;gt; I
gt;gt; gt;gt;gt;gt; gt;gt;gt; can
gt;gt; gt;gt;gt;gt; gt;gt;gt; go through them and see if they can be corrected or deleted.
gt;gt; gt;gt;gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt;gt; Which formula would work best for this project?
gt;gt; gt;gt;gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt;gt; Thanks for your help.
gt;gt; gt;gt;gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt;gt; Best regards,
gt;gt; gt;gt;gt;gt; gt;gt;gt; victor
gt;gt; gt;gt;gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt;
gt;gt; gt;gt;gt;gt; gt;gt;
gt;gt; gt;gt;gt;gt; gt;
gt;gt; gt;gt;gt;gt; gt;
gt;gt; gt;gt;gt;gt;
gt;gt; gt;gt;gt;gt;
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;
gt;gt; gt;gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;
gt;