+ Reply to Thread
Results 1 to 2 of 2

Data Validation : Ignore if Not Sequence

  1. 12-01-2017, 12:29 AM #1
    Jhon Mustofa
    Jhon Mustofa is offline
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Data Validation : Ignore if Not Sequence

    hi all...

    how to make formula fill series number (input) in data validation with criteria :
    126
    127
    129

    if number inputting not series so ignored it..
    it means fill series must sequence....

    thank..

    john m
    Reply With QuoteRegister To Reply
  2. 12-01-2017, 12:51 AM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Data Validation : Ignore if Not Sequence

    Use like
    A3=A2+1 or
    $A3=OFFSET($A3,-1,)+1
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data Validation Restrict-Always Sequence Number
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-24-2016, 11:18 AM
  2. Data validation formula : Sequence above
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-19-2014, 04:44 AM
  3. Data Validation - ignore blanks
    By Neville in forum Excel General
    Replies: 10
    Last Post: 11-09-2005, 10:10 AM
  4. [SOLVED] Ignore Blanks in Data Validation
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 09-06-2005, 12:05 PM
  5. [SOLVED] Ignore Blanks in Data Validation
    By Ricky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] Ignore Blanks in Data Validation
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 09-06-2005, 04:05 AM
  7. [SOLVED] Ignore Blanks in Data Validation
    By Ricky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1