Excel Help - Vowel count, but only display if 4 vowels or more

Discussion in 'Software' started by MZPRESTO, Feb 5, 2010.

  1. MZPRESTO

    MZPRESTO Private First Class

    Hi

    I need to do a Vowel count in Excel, but get excel to only show me examples of data where 4 or more vowels appear in a field.

    I found this formula on Google to do just a vowel count:

    =SUM(LEN(A1)-LEN(SUBSTITUTE(LOWER(A1),{"a","e","i","o","u"},"")))

    I have a list of 2000 fields and only want to filter fields that contain 4 or more vowels is this possible? and if so do I need to do it as a pivot table??? and how do I do that

    Thanks in advance!!!! This would help me out BIG TIME! :confused
     
  2. MZPRESTO

    MZPRESTO Private First Class

    Figured it out!!! using that same formula in a new column and using auto filter and custom filter, greater than or equal to!
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds