+ Reply to Thread
Results 1 to 16 of 16

Formula to Generate a list of codes

Hybrid View

  1. #1
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Formula to Generate a list of codes

    Quote Originally Posted by Animella View Post
    Here is an example
    Quote Originally Posted by Animella View Post
    Also I don't want the characters to bemore than 8 (including the 14k)
    Please confirm you WANT or you DONT WANT???


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  2. #2
    Registered User
    Join Date
    10-01-2013
    Location
    Cape town
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Formula to Generate a list of codes

    I do not want the code to be greater than 8. Can be equal to 8 but not greater.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Formula to Generate a list of codes

    Dragging down from 9th row to 10 row will make it as two digit 10.

    Like that it is based on the number of cells you apply the suggested formula it will go at a greater extent

+ 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. [SOLVED] Generate a range of sequential alpha numeric codes based on a from and to value
    By kenny.fsw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2013, 09:53 AM
  2. Using Formulas to Generate SKU codes
    By X-tremejoe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2013, 03:55 PM
  3. Using Formulas to Generate SKU codes
    By X-tremejoe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2013, 03:33 PM
  4. [SOLVED] need formula to count number of cells that contain any of a LARGE list of zip codes
    By Security in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-14-2012, 10:37 AM
  5. How to generate a LIST from codes
    By bitswit in forum Excel General
    Replies: 8
    Last Post: 08-22-2010, 05:33 PM

Tags for this Thread

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