Announcement

Collapse
No announcement yet.

how to find list of most frequent text in excel vba

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to find list of most frequent text in excel vba



    I have an excel file, and almost 1 lakh rows. In column A, i want to find the list of words/texts occurring most frequently - from max to min. Please can someone help?


  • #2
    Hello and Welcome to the Forum ...


    You can use the following Array formula :

    Code:
    =INDEX(yourRange,MODE(MATCH(YourRange,YourRange,0)))

    Hope this will help
    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment


    • #3
      Carim, THNX

      Comment


      • #4


        You are welcome
        If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

        Comment

        Working...
        X