+ Reply to Thread
Results 1 to 6 of 6

Sorting by Bold V. Normal Font

  1. #1
    Registered User
    Join Date
    07-07-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    6

    Sorting by Bold V. Normal Font

    Hi,
    I have a ton of lists to sort. Column A is the name of the person and column B is his/her email address. There are hundreds of rows filled with names & emails. Anyone who attended a certain event is listed in Bold (both name and email address). The people who didn't go to the event is written in a normal font (not in bold). I need to put all the people who attended the event (Bolded people and their emails) on the top of the page and the people who did not attend the event (non-bolded people and their email) at the bottom of the excel. How can I quickly do this? Thank you!
    Gretta

  2. #2
    Registered User
    Join Date
    07-07-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    6

    Re: Sorting by Bold V. Normal Font

    Also, can you give really clear directions when you answer this (like an answer for a beginner to Excel) - I am totally bad when it comes to the function formulas....

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Sorting by Bold V. Normal Font

    assuming first name is in a2 sheet 1 then select cell c2 then in name manager
    create a name say ISBOLD
    and in refers to put the formuls
    =GET.CELL(20,Sheet1!A2)
    in c2 type =ISBOLD
    fill down all
    those in col a that are bold will give true the rest false
    sort bY col c largest to smallest
    NOTE it must be a macro enabled workbook
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    07-07-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    6

    Re: Sorting by Bold V. Normal Font

    HI,
    Actually this just seems to identify the bolded names as True. I am trying to move all of the bold names to A2, A3, A4, etc - the top of the document, and all the non-bolded names to the bottom of the excel file. Please help. thanks so much! G

  5. #5
    Registered User
    Join Date
    07-07-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    6

    Re: Sorting by Bold V. Normal Font

    HI,
    Actually this just seems to identify the bolded names as True. I am trying to move all of the bold names to A2, A3, A4, etc - the top of the document, and all the non-bolded names to the bottom of the excel file. Please help. thanks so much! G

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Sorting by Bold V. Normal Font

    sort as i said by the true/false column select columa:c sort by column c large to small

+ 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. Replies: 6
    Last Post: 04-10-2014, 11:09 AM
  2. Need BOLD Font in VBA
    By rsanti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2012, 08:22 PM
  3. VBA - Add Font Bold
    By Redd in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-15-2007, 03:57 PM
  4. Replies: 1
    Last Post: 11-07-2007, 08:45 PM
  5. [SOLVED] how do i make one part of my formula bold and the other normal?
    By niquey in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2006, 10:25 AM

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