+ Reply to Thread
Results 1 to 7 of 7

Increment number based on Location 2

  1. 04-22-2024, 10:52 AM #1
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,069

    Increment number based on Location 2

    Variation to my previous thread below, I need to add "Inv" in front of the sequential number:
    https://www.excelforum.com/excel-for...ml#post5942743

    Thank you.

    Increment Number.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-22-2024, 10:57 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: Increment number based on Location 2

    How about in B3 copied down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 04-22-2024, 10:59 AM #3
    ben8563
    ben8563 is offline
    Forum Contributor
    Join Date
    03-28-2021
    Location
    China
    MS-Off Ver
    O365
    Posts
    111

    Re: Increment number based on Location 2

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 04-22-2024, 08:09 PM #4
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,469

    Re: Increment number based on Location 2

    Cell B2 formula , Drag down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 04-23-2024, 02:37 AM #5
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,069

    Re: Increment number based on Location 2

    All formulas work perfectly! Thank you!
    Reply With QuoteRegister To Reply
  6. 04-23-2024, 02:47 AM #6
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,469

    Re: Increment number based on Location 2

    josephteh You're Welcome. Glad to help . Thank You for the feedback and rep.
    Reply With QuoteRegister To Reply
  7. 04-23-2024, 06:31 AM #7
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: Increment number based on Location 2

    Glad to help & thanks for the feedback.
    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] Increment number based on Location
    By josephteh in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-22-2024, 02:44 AM
  2. [SOLVED] Formula required to Auto Increment number based on letter in another column
    By deneh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2015, 05:36 PM
  3. [SOLVED] Increment a Number in cells of same column based on how many of a specified data is found
    By BeachRock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-05-2013, 03:13 PM
  4. [SOLVED] Increment a number based on the text in the adjacent column
    By lday75 in forum Excel General
    Replies: 7
    Last Post: 07-27-2012, 03:42 PM
  5. Increment Date Based on Number of Pages Printed
    By [email protected] in forum Excel General
    Replies: 3
    Last Post: 12-14-2011, 08:04 PM
  6. Increment Date based on Worksheet number
    By IamDavidH in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2011, 03:46 PM
  7. how to auto increment cell location within formula
    By Bill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2006, 10:25 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