+ Reply to Thread
Results 1 to 3 of 3

check a value in a existing list, if exist increase value

  1. 10-22-2017, 06:46 PM #1
    lucholac
    lucholac is offline
    Registered User
    Join Date
    10-22-2017
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    5

    check a value in a existing list, if exist increase value

    I need to check a value in a existing list, if the value doesn't exist give extension _00 but if exist increase value by 1 (i.e. _03) in excel.
    Example
    1.- Value to check from the list below ***-DWG300
    2.- Value to check from the list below AXT-TST400


    ATS-ADS100_01
    ATS-ADS100_02
    ATS-ADS100_03
    ***-DWG300_00
    ***-DWG300_01
    ***-DWG300_02
    ***-DWG300_03
    ***-DWG300_04
    ***-DWG300_05 (1.- this should be the new value added to the list)
    AXT-TST400_00 (2.- this should be the new value added to the list)

    Thanking you in advance.
    Luis
    Reply With QuoteRegister To Reply
  2. 10-22-2017, 06:47 PM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello lucholac,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 10-23-2017, 05:18 AM #3
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,628

    Re: check a value in a existing list, if exist increase value

    As you may noticed - this is a "just welcome" sub forum. With any specific questions - publish them on appropriate sub forum. In this case, may be: https://www.excelforum.com/excel-for...and-functions/ would be the one to post. Or may be Programming/Macro one? I have not analyzed what kind of solution you look for.

    Enjoy the forum and follow the https://www.excelforum.com/forum-rul...rum-rules.html
    Best Regards,

    Kaper
    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] Check for existing File name, open if exist or open new workbook if not
    By COURTTROOPER in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2017, 12:32 AM
  2. [SOLVED] If words exist return answer, if not then use existing formula
    By ScaniaR730 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-06-2016, 06:09 AM
  3. Check if sheet exist based on drop down list
    By oerberg in forum Excel General
    Replies: 3
    Last Post: 03-23-2016, 11:55 AM
  4. [SOLVED] Check First IF Sheet Is Exist With The Name Of Cell K7 If exist Then run the code
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-18-2015, 10:08 AM
  5. open existing file if exist, else create it.
    By simeonmein in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2014, 11:17 AM
  6. [SOLVED] Check data from existing list
    By khannan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2013, 08:42 AM
  7. Check If Folders in a List Exist
    By fionaby in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2012, 09:32 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