+ Reply to Thread
Results 1 to 3 of 3

Creating. Excel Formula

  1. #1
    Registered User
    Join Date
    06-22-2018
    Location
    London, England
    MS-Off Ver
    Mac 2016
    Posts
    1

    Creating. Excel Formula

    Hi

    I wonder if someone can help me, I am looking to create a formula where excel is able to search column A, and if it finds a duplicate it will add PT01 at the end. If it finds a further duplicate with the same value it will add PT02, and so forth up until PT15.

    I have attached an example.

    Any help would be appreciated. Thank you!
    Attached Images Attached Images

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,861

    Re: Creating. Excel Formula

    A picture is not much use - why not attach the Excel workbook?

    Try this in C2:

    =IF(A2="","",A2&" - PT"&TEXT(COUNTIF(A$2:A2,A2),"00"))

    Then copy down.

    Hope this helps.

    Pete

  3. #3
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,884

    Re: Creating. Excel Formula

    Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

    Use concise, accurate thread titles.
    Your post title should describe your problem, not your anticipated solution.
    Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
    Responding to a request to change your thread title by doing so is mandatory.

    To change a title go to your first post, click EDIT then Go Advanced and change your title.

    No help to be offered, please, until the OP complies with this request.

    When you have changed the title, please also give full details of the problem in the body of your post - nobody should have to open an attachment to find out what you want.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. I Need Help Creating a Complex Formula in Excel
    By hamilton_00 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-11-2015, 08:44 AM
  2. Need help creating formula in Excel 2007
    By tshirtgrg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2012, 08:29 PM
  3. need help with creating formula in excel
    By gauravi in forum Excel General
    Replies: 1
    Last Post: 01-25-2007, 06:32 AM
  4. Need help on creating a formula in excel
    By tbarrows in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-25-2006, 12:35 AM
  5. [SOLVED] Creating an Excel Formula
    By clark1269 in forum Excel General
    Replies: 1
    Last Post: 07-23-2006, 07:10 PM
  6. Creating a formula in excel
    By lissasusan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2006, 05:15 PM
  7. [SOLVED] Looking for information on creating a formula in excel
    By George A. Yorks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2005, 08:07 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