+ Reply to Thread
Results 1 to 3 of 3

Formula required- A3= 1S; how to make A4=2S, A5=3S

  1. #1
    Registered User
    Join Date
    08-12-2004
    Location
    Mendoza, Argentina
    MS-Off Ver
    Office Professional 2003
    Posts
    89

    Formula required- A3= 1S; how to make A4=2S, A5=3S

    I can't work out a formula that I can copy and paste for 300+ rows (which can be sorted ascending or descending.
    I have several spreadsheets that each have reference numbers starting at 1.

    I may have to join the sheets and keep the reference different by adding a letter as well. Thus I need a formula that will augment the number by 1 but will also have a letter to identify from which sheet it has come. which letter is used is not important.

    Cell A 3 must be 1A
    Formula required to make
    A4 = 2A
    A5 = 3A etc.

    many thanks

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Formula required- A3= 1S; how to make A4=2S, A5=3S

    Try:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    08-12-2004
    Location
    Mendoza, Argentina
    MS-Off Ver
    Office Professional 2003
    Posts
    89

    Re: Formula required- A3= 1S; how to make A4=2S, A5=3S

    Thank you OllyXLS - just what I wanted. Apart from not knowing the ROW() function, I was trying "+" and not the "&".

    Many thanks - I knew it had to be simple!!

+ 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. Macro that will make fields required
    By sarai77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 04:30 PM
  2. Can I make certain cells required?
    By ~C in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-02-2006, 02:50 PM
  3. How do I make a particular column required in Excel?
    By smistretta in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-24-2006, 04:00 PM
  4. can you make a cell value required?
    By nishapurohit in forum Excel General
    Replies: 2
    Last Post: 01-30-2006, 07:42 PM
  5. Make a cell required
    By cpointcc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2005, 04:44 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1