Results 1 to 11 of 11

3 consecutive vowels categorise

Threaded View

  1. 03-29-2024, 03:48 AM #1
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,617

    3 consecutive vowels categorise

    Please look at this logic

    ARCHAEA
    ALTHAEA
    TAIAHAS
    MANAIAS
    WAIATAS

    Say those are on A1

    Need formula on b1 drag down to give below

    AEA
    AEA
    AIA
    AIA
    AIA

    Need formula to search 3 consecutive vowels in the word and pull that at B

    Find file attached , with expected results for the first 5 words

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sort LIST by 3 vowels and 4 vowels and 5 vowels
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-01-2024, 11:10 PM
  2. Categorise by percentage
    By MontyBoi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-15-2023, 01:24 PM
  3. mark Y if word has 4 consecutive vowels
    By makinmomb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-20-2023, 08:22 AM
  4. Categorise a score
    By Jonny46wakey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2021, 09:49 AM
  5. [SOLVED] Any three consecutive vowels summary
    By makinmomb in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-22-2017, 11:33 AM
  6. How do you categorise items please
    By joj123 in forum Excel General
    Replies: 3
    Last Post: 05-31-2014, 12:07 PM
  7. Excel 2007 : How to categorise into hours.
    By kanigelpula in forum Excel General
    Replies: 0
    Last Post: 08-15-2011, 11:42 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1