• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    FIlter by begins with

    Thanks to both of you. I was working on Faseeh's answer, when I saw Deb's. It seems to be easier for me to understand, and so far is working great. Thanks again!
  2. N

    FIlter by begins with

    Hey everyone, I'm lost again!. I have lots of data (over 650k lines) that I need to filter by the first numeral so that I can apply certain formulas to that group. I can't use the "between" filter because some of my numbers are 6 digits and some are 7 digits. I have tried changing the...
  3. N

    Pivot Table without a calculation?

    Thanks! I had to change my pivot table options for layout, but it works! Thanks again!
  4. N

    Pivot Table without a calculation?

    Hi Everyone! I am trying to figure out something in pivot tables. My data looks like this: DN x ST CPM 201204 0 NJ 0.00439 201204 1 NJ 0.00514 201204 2 NJ 0.00138 201204 3 NJ 0.0047 201204 4 NJ 0.00407 201204 5 NJ 0.00407 201204 6 NJ 0.00138 201204 7 NJ 0.00138 201204 8 NJ 0.00195...
  5. N

    Subtotal - Max and Min at one time?

    wow, thanks so much, both of you. I'll give these a try!
  6. N

    Subtotal - Max and Min at one time?

    I have a lot of lines of data to compare. I need to find the min and max of a series of numbers. The first 6 digits are the same, but each range could include 2-10 numbers to compare. I have been using SUBTOTAL with the MAX function, and then again with the MIN function (not replacing...
Back
Top