Results 1 to 2 of 2

count the number of times a number appears in a specific range

Threaded View

myjebay1 count the number of times a... 05-17-2013, 02:26 PM
JBeaucaire Re: count the number of times... 05-18-2013, 11:01 AM
  1. #1
    Registered User
    Join Date
    10-21-2011
    Location
    baltimore,md
    MS-Off Ver
    Excel 2003
    Posts
    53

    count the number of times a number appears in a specific range

    Hey
    I was having some trouble with this macro hoping I could get some assistance!

    So, starting with cell D254 look for the following values: 110, 130, 150, and 160.
    in the cells D254, F254, H254, J254, and L254. then go to D255 and do the same things for F, H, J, and L255.
    Continue this count untill Line 1454 and put the totals for the four numbers at the end of the document (preferably coluumns a, b, c and d

    One caveat is to not add an instance to the total if the previous checked cell has the same value.
    (so if F255 is 110 and D255 is 110, don't count F255. or if D255 is 110 and L254 is 110 dont count D255)

    This would be greatly appreciated.

    thank you~!

    jeb
    Attached Files Attached Files
    Last edited by myjebay1; 05-17-2013 at 03:20 PM.

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