User Profile

Collapse

Profile Sidebar

Collapse
DANNYOCEAN
DANNYOCEAN
Last Activity: Dec 18 '13, 04:28 PM
Joined: Oct 8 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • DANNYOCEAN
    replied to Count multiple criteria vba excel
    in Access
    the code that is working for only one mathematical condition is, for example numbers are lower than 45 :

    Code:
    Sub COUNT()
Dim ARRDATA As Variant '§ with range=>array must ALLWAYS be variant.
Dim ROWidx As Integer
Dim COLidx As Integer
'§ COLidxlect amount
Dim ARRCOUNTER() As Integer '§ count results for each line
Dim COUNTER As Integer
Dim TOTAL As Integer
'§ COLidxlect numbers
    ...
    See more | Go to post
    Last edited by Stewart Ross; Dec 30 '12, 06:44 PM. Reason: Added code tags for you

      Leave a comment:

    • DANNYOCEAN
      started a topic Count multiple criteria vba excel
      in Access

      Count multiple criteria vba excel

      I have a code that sucessfully calculates how many numbers are lower than for example 45 , for large sample number list.

      But i´m looking for a code that have a COUNT function with MULTIPLE CRITERIA such as, for example:

      i wanna know which are the numbers and how many of them follow the MULTIPLE CRITERIA: [lower than or equal to 5 (<=5)] OR [lower than or equal to 15 AND higher than or equal to 11 (>=11 And <=15)]...
      See more | Go to post
      • DANNYOCEAN
        replied to repetitiveness of numbers with the same ending
        in Visual Basic
        I read the notation that you used above. May I borrow to explain better:
        for each digit ENDING on 1 it's :
        So for 1, 11, 21 it should counting FRQ1=3, not 4 as it seems that the last macro is counting in the wrong way.

        for each digit ENDING on 7 it's :
        67 20 55 74 45 48 85 91 79 57 47 22 17 54

        So for 67,57, 47, 17 But it must be FRQ7=4 not 6, cause it´s counting 74 and 79, but both don´t end...
        See more | Go to post

          Leave a comment:

        • DANNYOCEAN
          replied to repetitiveness of numbers with the same ending
          in Visual Basic
          I opened the file, I runned the macro that you provided.
          It works well,
          but it´s counting the wrong way: it´s counting 14 as 41. but 14 is not 41.
          I mean that the macro should count all possible numbers with the same numbers ending... 21, 61 must count 2 not 3 is the spreadsheet.
          I think that this macro is counting 14 as 41. See the 1st line the spreadsheet. I think that this error happens in other lines, cause I compared...
          See more | Go to post

            Leave a comment:

          • DANNYOCEAN
            replied to repetitiveness of numbers with the same ending
            in Visual Basic
            I opened the file, but it runs then stops. the follow error message appears : error in execution time "13"
            and in vb appears in yellow in the code, with an arrow point on it: Call Set_Frequency(R ight(ARRAYDATA( ARRAYDATAidx, ARRAYDATACOLidx ), 1), ARRAYDATAidx)
            See more | Go to post

              Leave a comment:

            • DANNYOCEAN
              replied to repetitiveness of numbers with the same ending
              in Visual Basic
              I was wondering that's possible to make this in visual basic/ excel but I don´t know how to start.
              My visual basic is 6.3
              I´d like to this, to calculate the frequency/repetition for each line for a huge number list in a spreadsheet like excel. See the attachment as example for a extremely large number list

              Can you give some help??
              Thanks in advance...
              See more | Go to post

                Leave a comment:

              • DANNYOCEAN
                started a topic repetitiveness of numbers with the same ending
                in Visual Basic

                repetitiveness of numbers with the same ending

                hello guys!
                how are you?
                I'd like to know to calculate the frequency/repetition of all possible numbers with the same ending (doing this for all endings from 0 to 1) for each line
                for example:
                line a:65 67 10 20 51 55 68 35 69 75 79 80 84 85 90 95 30 40 98
                frequency of ending 0: 7
                frequency of ending 1: 1
                frequency of ending 2: 0
                frequency of ending 3: 0
                frequency of ending 4: 1...
                See more | Go to post
                No activity results to display
                Show More
                Working...