Results 1 to 14 of 14

Sequential number in column but only if other column contains certain criteria

Threaded View

  1. 12-15-2023, 05:22 AM #1
    iammike
    iammike is offline
    Forum Contributor
    Join Date
    02-19-2020
    Location
    SE-Asia
    MS-Off Ver
    2019
    Posts
    126

    Sequential number in column but only if other column contains certain criteria

    See attached sheet

    Need your help again

    I want the Nr in Column A be filed sequential but only if Column E has a value of 1

    If Column E is another value then 1 (for example "adv" or 0) then Column A
    should stay Empty.

    I hope the example is clear

    Ps: Just for my understanding, can you please first give me a hint on how to solve this on my own, instead of ready made solution.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. how to highlight more than one column after non sequential number/Date?
    By FakeFace in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2023, 01:28 PM
  2. [SOLVED] Combine Column Values + Sequential Number to Create Smart ID Number
    By Nonoffensive Name in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2020, 05:10 PM
  3. VBA - Insert next sequential number from series in a column
    By pingman3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2018, 02:01 AM
  4. [SOLVED] Summing row ranges based on non-sequential column criteria
    By TexasKersh in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-20-2014, 08:21 AM
  5. How to add sequential numbering down a column until the next number 1 and start over
    By diaphanous1138 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-13-2014, 04:52 PM
  6. Fill sequential number down empty column, save last number, use as first number next time
    By shepardrf in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-30-2013, 07:29 PM
  7. Populate column in sequential order by number of records
    By araki in forum Excel General
    Replies: 1
    Last Post: 04-28-2006, 02:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1