+ Reply to Thread
Results 1 to 4 of 4

Avoid recounting duplicate sequence

  1. #1
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2016 & Office365
    Posts
    139

    Post Avoid recounting duplicate sequence

    Good day,

    I just need to avoid recounting duplicate sequence number.
    like if i receive sequence# from 11 to 15 (total:5) then the next one are 15 to 20 (total:6),
    since seq#15 previously received, it should not recount again from total count received
    total count received should be 10 & not 11 (seq.#11 to 15 = 5) + (seq#15 to 20 = 6)

    See attached file for example...
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,522

    Re: Avoid recounting duplicate sequence

    Change the function to
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2016 & Office365
    Posts
    139

    Re: Avoid recounting duplicate sequence

    Thank you again Mr. Jindon...

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,522

    Re: Avoid recounting duplicate sequence

    If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Avoid recounting duplicated or in between range
    By amberle in forum Excel General
    Replies: 1
    Last Post: 05-09-2016, 10:05 AM
  2. [SOLVED] Set up avoid duplicate problem
    By aleman_li in forum Excel General
    Replies: 2
    Last Post: 04-23-2015, 10:12 AM
  3. avoid duplicate when entry from list
    By corescript in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2012, 02:45 AM
  4. Excel 2007 : How to avoid duplicate entry
    By suhail in forum Excel General
    Replies: 4
    Last Post: 10-24-2010, 10:17 PM
  5. Avoid Duplicate Names
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 01:48 PM
  6. Code to avoid duplicate userforms
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2009, 08:30 AM
  7. Avoid Duplicate Records
    By Amarjeet Singh in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-22-2009, 09:05 PM

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