Filter column grater than 7 days ageing

vijayarc

New Member
Joined
Aug 2, 2018
Messages
2
  • <article>
    Hi sir

    I want macro to filter column which is grater than 7 days ageing , trick part is
    columns value will be like, mixed up​
    </article>

  • <article>
    Completed - 14 Days
    Completed - 0 Days
    Rejected - 84 Days
    Rejected - 103 Days
    Completed - 0 Days
    Rejected - 84 Days
    WIP - 601 Days
    NotStarted - 684 Days
    NotStarted
    NotStarted - 84 Days

    I want to filter only WIP-601 days 'NotStarted', NotStarted - 684 Days
    (all days grater than 7 days only)

    please find my sample file in 'M , N 'column I need to filter
    kindly help and do needful​
    </article>
#Rows("1:1").Select
Selection.AutoFilter
Columns("Z:BC").Select
Selection.Delete Shift:=xlToLeft
ActiveSheet.AutoFilterMode = False

Range("A1:V1").Select

Selection.AutoFilter
ActiveSheet.Range("A1:S1").AutoFilter Field:=9, Criteria1:=Array( _
"WIP - LOB", "Rejected"), Operator:=xlFilterValues

'' filter m, n columns ageing grater than 7 days "
'
''
''
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Hi Ninja Team
  • <article>

    • <article>
      Please help on my below query
      in my excel, when i click upload Dashboard button and i upload the dashboard file by browse then the data will copy in Batch_Report sheet
      based on my code module for each sheets, the data will filter and delete columns and save on each sheets,
      i have different filter condition for each sheets.

      here i am facing issue is - on Daily_Pro sheet under columns M,N on TS and Credit header, i want to filter the condition as: 'NotStarted, Notstarted - 68 days' (all days should be grater then 7 days)
      'Notstarted - 2 days' - should not filter, because it less than 7 days
      Notstarted - 0 days' - should not filter, because it less than 7 days
      Notstarted - 6 days' - should not filter, because it less than 7 days
      Notstarted - 7 days' - should filter, because it equal to 7 days

      in attached image, i coded wildcard search filter, but it filter all days.

      please help and advise how to filter for above condition
      i want the code should place on module 1- below the filter condition code as per image for my understanding, the same code i wan to respect for other sheets and columns​
      </article>
    </article>
''
''
pls help for above request
 
Upvote 0
how about excel formula
=IF( IFERROR(FIND("-",A2)>0,FALSE), SUBSTITUTE(MID(A2,FIND("-",A2)+2,100)," Days","")*1 ,0)

for some reason trim would not get rid of last space in second row
" Days " may cause an error.
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top