Need help with microsoft excel formula

Discussion in 'Lounge' started by samsome, Sep 24, 2021.

  1. samsome

    samsome Guest

    i have a list of words all are below each other 1 by 1

    i need all words that contain more than 2 a's to be highlighted

    anyone knows how to do it
     
    samsome, Sep 24, 2021
    1
  2. Ads Master

    Ads Master

     
  3. Chichan

    Chichan Member

    Joined:
    Aug 23, 2021
    Messages:
    21
    Likes Received:
    16
    Best Answer
    Sure, this will do it....

    The list of words you mention sound like they are in a column. Highlight the cells in this column that you wish to process and make a note of the location of the top most cell - let's assume it is A1.

    On the excel home tab select Conditional Formatting > Highlight Cells Rules > More Rules and select "Use a formula to determine which cells to format. Enter this formula =IF((LEN(A1)-LEN(SUBSTITUTE(A1,"a","")))>2,TRUE,FALSE). Click the format button to choose the type of formatting you wish to use and then click OK to apply.
     
    Chichan, Sep 24, 2021
    2
  4. samsome

    samsome Guest

    thanks! :D
     
    samsome, Sep 24, 2021
    3
  5. orbitbooster

    orbitbooster Audiosexual

    Joined:
    Jan 8, 2018
    Messages:
    1,187
    Likes Received:
    663
    In past I used a lot to code VBA for Excel, but for some unknown reason now I cannot install developer plugin so I cannot try a macro.
    "Debugging".
     
    orbitbooster, Sep 24, 2021
    4
  6. Sowrepsia

    Sowrepsia Newbie

    Joined:
    Aug 7, 2024
    Messages:
    2
    Likes Received:
    0
    I know it's been a while, but I get how tricky Excel formulas can be sometimes. I’ve had my share of confusion with them, too. If you’re looking for a straightforward way to tackle this, I suggest checking out excel online. It’s super user-friendly and offers handy templates that might help clear things up. Plus, you can find many tutorials and tips that break things down step by step.
    When I was learning, playing around with the formulas was helpful. Don’t be afraid to experiment! If you mess something up, just hit the undo button.
     
    Last edited: Aug 13, 2024
    Sowrepsia, Aug 7, 2024
    5
Loading...
Similar Threads - Need help microsoft Forum Date
Need Help installing Kontakt 8 libraries Software Monday at 5:18 PM
Any good KSP scripters around? Need help with Kontakt GUI Maker Software Saturday at 11:18 AM
Downsampling Help Needed: Aliasing Prevention Working with Sound Feb 12, 2025
need help to install stem sepation extention in studio one 7 R2R Studio One Jan 29, 2025
new need help finding sister site Lounge Jan 18, 2025
Loading...