Filter, Remove then average left overs

**rmrjr22** · 10-28-2015, 12:24 PM

I have been trying to find a way to Filter two Columns.
First by filtering the "Part number" so that they are grouped, which I believe I have done.
From there, filter the "Status" by removing anything with an "F", then deleting that row.
Next remove anything else that does not contain "Pass", "P_TC" and "PTC".
All that should be left when filtering the "Status" is "Pass", "P_TC" and "PTC".
And lastly, the averaging of "Zero" and "Span" values for each "Part Number".

Maybe I am doing it in the wrong order.

Any help in the right direction will be valued.
Thank you in advance.

**AlphaFrog** · 10-28-2015, 01:08 PM

This will filter the status and delete the rows.

    Dim v As Variant
    
    Application.ScreenUpdating = False
    With ActiveSheet
        If .FilterMode Then .ShowAllData
        .Columns("A:AZ").Hidden = False
        .Columns("A:AZ").AutoFilter Field:=2, Criteria1:=Array("*Pass*", "*P_TC*", "*PTC*"), Operator:=xlFilterValues
        v = .AutoFilter.Range.SpecialCells(xlCellTypeVisible).Value
        .AutoFilterMode = False
        .UsedRange.ClearContents
        .Range("A1").Resize(UBound(v, 1), UBound(v, 2)).Value = v
        .Columns("C:H").Hidden = True
    End With
    Application.ScreenUpdating = True

I'm not sure where you want to put the part number averages. It would be easy to create a Pivot Table of averages somewhere.

**rmrjr22** · 10-28-2015, 01:24 PM

I would like to put the average value at the end of the list.
Perhaps with a "Average" label at the end of "Status", which would lie next to the average values?
I put a question mark, because i am not sure if such a thing is possible...

Filter, Remove then average left overs

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Filter, Remove then average left overs

Re: Filter, Remove then average left overs

Re: Filter, Remove then average left overs

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to count cricket overs?

Filter unique Values without macro/advanced filter/remove duplicates

Who do I average in a filter that currently uses a formula for calculating average based..

[SOLVED] Remove left and top bar

Code for mouse-overs?

Excel 2007 : Remove from right to left up to a first symbol

How Can I Remove Everything to the Left of...

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions