Results 1 to 5 of 5

counting the occurrence of a set of continguous values

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    British Columbia, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Post counting the occurrence of a set of continguous values

    I have one column of information.
    It ranges from cells A1 to A20000.
    For simplicity, the values in the cell is a 5-digit number that can range from 10000-30000.

    I would like to look only at the first three digits of the data set.
    Looking at cell A1 (value is 13245), how many occurences of '132' can I find in the range A1-A20000?
    Then looking at cell A2 (value is 16756), how many occurences of '167' can I find in the range A1-A20000?
    Continue this with each cell until cell A20000.

    Next step, I want to look only at the second, third, and fourth digits of the data set.
    So looking at cell A1 (value is 13245), how many occurences of '324' can I find in the range A1-A20000?
    Then looking at cell A2 (value is 16756), how many occurences of '675' can I find in the range A1-A20000?
    Continue this with each cell until cell A20000.

    Next step, I want to look only at the third, fourth, and fifth digits of the data set.
    So looking at cell A1 (value is 13245), how many occurences of '245' can I find in the range A1-A20000?
    Then looking at cell A2 (value is 16756), how many occurences of '756' can I find in the range A1-A20000?
    Continue this with each cell until cell A20000.

    Any help would be greatly appreciated!

    Thanks!
    Last edited by 2013April; 04-12-2013 at 12:14 AM. Reason: clarification

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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