+ Reply to Thread
Results 1 to 1 of 1

Count all elements in first dimension of an array that are equal to one?

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    19

    Count all elements in first dimension of an array that are equal to one?

    HI all,

    I have written a script that creats an array, it is very large, but i have checked it and it works well. Here is the code

    Please Login or Register  to view this content.
    What i need to next is count the total number of "1"'s in each column of the new array....WinArr().

    So say the array (WinArr) is 40 columns wide. I need to count all the "1"'s in the first column, then the second column etc to the fortieth column

    IS there a quick was to do it? Rather than cycling through each element and checking it is a "1"?

    Rgds

    Surreall
    Last edited by Surreall; 01-23-2013 at 12:43 PM.

+ 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