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,123
    Likes Received:
    626
    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:
    1
    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
Help Needed: Drum Replacing! Software Monday at 3:35 AM
Help Needed: UVR Models!! Software Friday at 8:29 PM
Help Needed: Ultimate Vocal Remove (UVR) Software Nov 17, 2024
Solved: Sample Calculation Help Needed Working with Sound Nov 7, 2024
Need help please Computer Hardware Nov 4, 2024
Loading...