+ Reply to Thread
Results 1 to 6 of 6

macro to put an asterisk nex to the first new name in a column then sort.

  1. #1
    Registered User
    Join Date
    06-08-2012
    Location
    california
    MS-Off Ver
    Excel 2007
    Posts
    28

    macro to put an asterisk nex to the first new name in a column then sort.

    Can someone please help me to do the following:

    I need to find in a very long column, the first of each Program, by placing an asterisk next to each new program then sorting them.

    LOT Polish Airlines B787 Line Fit
    LOT Polish Airlines B787 Line Fit
    Saudi Arabian Airlines B777-322 HD Retro
    Saudi Arabian Airlines B777-322 HD Retro
    Saudi Arabian Airlines B777-322 HD Retro
    Etihad A340-600 Line Fit ETD08
    Air France A380 Line Fit
    Air France A380 Line Fit
    Air France A380 Line Fit
    Air India B747-400 Retro
    Air India B747-400 Retro
    FSTA A330-200 Airtanker Line Fit
    Etihad A340-600 Line Fit ETD08
    Etihad A340-600 Line Fit ETD08
    Etihad A340-600 Line Fit ETD08
    Etihad A340-600 Line Fit ETD08
    Air France A380 Line Fit
    Etihad A340-600 Line Fit ETD08
    Etihad A340-600 Line Fit ETD08
    Etihad A340-600 Line Fit ETD08

    It goes on and on with multiple rows of each seen above and more.

    Thank you in advance.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,094

    Re: macro to put an asterisk nex to the first new name in a column then sort.

    With your data starting in A2, you could put this formula in B2 and copy down then sort by the asterisk.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    06-08-2012
    Location
    california
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: macro to put an asterisk nex to the first new name in a column then sort.

    i Jeff,

    The formula you gave was great. That part worked beautiful, Thanks. The problem now is that it won't sort on B and give me all the asterisks at the top. Did I do something wrong?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,094

    Re: macro to put an asterisk nex to the first new name in a column then sort.

    Once the formula is entered >> highlight column B >> right click >> copy >> paste special as values

    Now sort column B ascending.

    Is this a periodic thing or something which you will do often?

    If often, here is a macro. Adjust where required.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-08-2012
    Location
    california
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: macro to put an asterisk nex to the first new name in a column then sort.

    Yes this will be an on-going thing. The Macro worked perfectly. Thank you so very much.

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,094

    Re: macro to put an asterisk nex to the first new name in a column then sort.

    You are most welcome and thanks for the rep.

    Glad it worked out for you and as always, we appreciate the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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