software

I have created an advanced filter using the first two columns which contain
quot;Yesquot; to copy to another location. Now they would like me to take the
remaining items which would contain quot;Noquot; or be blankquot; after the Yes items.
Not sure how to update the criteria range. Right now I have;

Standard Documentationquot;Yesquot; if Optional Required
Yes
Yes

Can anyone advise how to bring in the other items after the Yes's.

Thanks
Havenstar!

It's not clear what you're trying to filter. Can you show some sample
data, and the results you'd like to get?

Havenstar wrote:
gt; I have created an advanced filter using the first two columns which contain
gt; quot;Yesquot; to copy to another location. Now they would like me to take the
gt; remaining items which would contain quot;Noquot; or be blankquot; after the Yes items.
gt; Not sure how to update the criteria range. Right now I have;
gt;
gt; Standard Documentationquot;Yesquot; if Optional Required
gt; Yes
gt; Yes
gt;
gt; Can anyone advise how to bring in the other items after the Yes's.
gt;
gt; Thanks
gt; Havenstar!--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlSure....the first column is protected so they are unable to change the 2nd
column they can either put yes, no or leave blank. What I want to do is sort
with the Yes's from both columns, then the no's and blanks to another
location.

Standard
DocumentationOptional Required Description
Yes Manual Set Up Time
Yes Owner’s General Instructions
Yes Bill of Materials-Mechanical
Yes Spare Parts List amp; Pricing
Yes Mill / Material Test Reports
No Supplied Component Manuals
Yes Main Assembly quot;As-builtquot; Dwgs
ASME Manufacturers Data Report

This list is in excel and we then copy and past into a word document and
send to the customer documentation requiremenst (Yes') and the other items
are optional (No and Blanks')

Hope this helps!
Havenstar

quot;Debra Dalgleishquot; wrote:

gt; It's not clear what you're trying to filter. Can you show some sample
gt; data, and the results you'd like to get?
gt;
gt; Havenstar wrote:
gt; gt; I have created an advanced filter using the first two columns which contain
gt; gt; quot;Yesquot; to copy to another location. Now they would like me to take the
gt; gt; remaining items which would contain quot;Noquot; or be blankquot; after the Yes items.
gt; gt; Not sure how to update the criteria range. Right now I have;
gt; gt;
gt; gt; Standard Documentationquot;Yesquot; if Optional Required
gt; gt; Yes
gt; gt; Yes
gt; gt;
gt; gt; Can anyone advise how to bring in the other items after the Yes's.
gt; gt;
gt; gt; Thanks
gt; gt; Havenstar!
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

You could copy the list to another sheet, and add a column to calculate
if there is a Yes in the row:

=IF(COUNTIF(A2:B2,quot;Yesquot;),1,2)

Sort on the new column, then you could delete the column.

Havenstar wrote:
gt; Sure....the first column is protected so they are unable to change the 2nd
gt; column they can either put yes, no or leave blank. What I want to do is sort
gt; with the Yes's from both columns, then the no's and blanks to another
gt; location.
gt;
gt; Standard
gt; DocumentationOptional Required Description
gt; Yes Manual Set Up Time
gt; Yes Owner’s General Instructions
gt; Yes Bill of Materials-Mechanical
gt; Yes Spare Parts List amp; Pricing
gt; Yes Mill / Material Test Reports
gt; No Supplied Component Manuals
gt; Yes Main Assembly quot;As-builtquot; Dwgs
gt; ASME Manufacturers Data Report
gt;
gt; This list is in excel and we then copy and past into a word document and
gt; send to the customer documentation requiremenst (Yes') and the other items
gt; are optional (No and Blanks')
gt;
gt; Hope this helps!
gt; Havenstar
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt;
gt;gt;It's not clear what you're trying to filter. Can you show some sample
gt;gt;data, and the results you'd like to get?
gt;gt;
gt;gt;Havenstar wrote:
gt;gt;
gt;gt;gt;I have created an advanced filter using the first two columns which contain
gt;gt;gt;quot;Yesquot; to copy to another location. Now they would like me to take the
gt;gt;gt;remaining items which would contain quot;Noquot; or be blankquot; after the Yes items.
gt;gt;gt;Not sure how to update the criteria range. Right now I have;
gt;gt;gt;
gt;gt;gt;Standard Documentationquot;Yesquot; if Optional Required
gt;gt;gt;Yes
gt;gt;gt; Yes
gt;gt;gt;
gt;gt;gt;Can anyone advise how to bring in the other items after the Yes's.
gt;gt;gt;
gt;gt;gt;Thanks
gt;gt;gt;Havenstar!
gt;gt;
gt;gt;
gt;gt;--
gt;gt;Debra Dalgleish
gt;gt;Excel FAQ, Tips amp; Book List
gt;gt;www.contextures.com/tiptech.html
gt;gt;
gt;gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html