+ Reply to Thread
Results 1 to 2 of 2

Column clean up - Eliminating prefixes

Hybrid View

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2013
    Posts
    87

    Column clean up - Eliminating prefixes

    Hey guys,

    I have a column that contains numerical information (the fields are "general"). Some of the numerical fields have either ">, >=, <, <=" before the number. However, based on the data filtering I am doing, these prefixes affect the search.

    How would I go about removing these prefixes? or somehow still manage to count the data with the prefixes?

    Example of the filter code I have:
       
        With ws1
           .Activate
           DataDate = Application.WorksheetFunction.CountIfs(Range("Q:Q"), ">60", Range("R:R"), ">=" & Date12Months)
        End With

  2. #2
    Registered User
    Join Date
    10-24-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2013
    Posts
    87

    Re: Column clean up - Eliminating prefixes

    I hope I was clear when I explained this.

    Is there a method to remove "prefixes" but leave the numerical value?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1