• 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. L

    copy random rows

    Hi How to copy random rows without duplicates from one sheet to another in vba? your help will be appreciated
  2. L

    Vba Filter

    Vba filter Here is a sample ,I use for filtering one combination at time , using the sumproduct/countif function, and I do the filtering manually as it’s shown on my sample,it’s time consuming when you have hundreds of thousands of rows, I will appreciate, if a gentleman/women could provide me...
  3. L

    integer filter

    How to filter rows of numbers 6 cells,and show only rows containing 4_5_6 matching numbers? i 'm compairing 3000 rows list against 100000 rows list. Assistance will be immensly appreciated.
  4. L

    sumproduct(countif combo

    Hi new comer need help with the following formulas i have 6 columns a2/a100 to f2/f100 with (6 numbers)each row / and i have h2to m2 (6 numbers) i'm using this formula'=SUMPRODUCT(COUNTIF($H$1:$M$1,A2:F2))' it's working but what i need is instead of showing all the count from 0 to 6 ,i need...
Back
Top