+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Counting Values and Unique Values within a 1 minute Time Interval

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007/2010
    Posts
    2

    Counting Values and Unique Values within a 1 minute Time Interval

    I'm hoping you intelligent people here can help me out. I have a two part issues. First, I need an Excel formula to break up Column A into 1 minute intervals. Second, I am looking for two formulas:

    1) Count Unique Values (Alphanumeric) within a time interval (usually one minute)
    2) Count All Values (Alphanumeric) within a time interval (usually one minute)

    In my attached example there are only 21 data sets. I usually deal with 1000+ data sets, so doing it manually is not an option.

    If this should be done in a completely different, I'm all ears.

    Thanks for taking your time to help me out.

    V/r,
    Minh
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Counting Values and Unique Values within a 1 minute Time Interval

    hi minh.d.nguyen, welcome to the forum.
    for the unique items, u can try:
    Please Login or Register  to view this content.
    use CTRL + SHIFT + ENTER to enter after keying the formula

    for item counts, try:
    Please Login or Register  to view this content.
    let me know if it works

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    06-05-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007/2010
    Posts
    2

    Re: Counting Values and Unique Values within a 1 minute Time Interval

    Thanks, I'll give it a try and let you know.

+ 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