most common text string

  1. E

    Find the 1st/2nd/3rd Common Text w/ Criteria

    Hi all, Looking for a formula that will give me the result of the most common text within my dataset. I currently have, for the first common text result the following formula : {=INDEX(tblMain[Placement Provider],MODE(IF(tblMain[Reporting Fin-Year]=RIGHT(E4,5),IF(tblMain[Placement...
    • _eNVy_
    • Thread
    • array criteria based most common text string text
    • Replies: 2
    • Forum: Excel Questions
  2. L

    2nd, 3rd, ... nth most common text within a date range

    I have searched all over for a solution to this and I am beyond flummoxed. Don't let me down... My data is in two columns (Diagnosis and Date) and I need to know the 1st - 3rd most common Diagnoses within a particular date range. Diagnosis Date Autism 1/31/18 Down's Syn 12/5/17...
  3. Fishboy

    Counting most common text value of column - within date range

    Hi all, I am currently using the following formula in Excel 2010: =INDEX('Contact History'!C:C,(MODE(MATCH(C:C,C:C,0)))) What it does is look at the sheet called "Contact History", checks column C and reports the most common contact name. So far so good. What I am trying to add in to the...
    • Fishboy
    • Thread
    • excel 2010 index match mode most common text string
    • Replies: 3
    • Forum: Excel Questions
  4. L

    Link Name that appears most To Another Cell if Filtered

    Hello, I can't figure out the following: I have a list of names as part of a table in Column D: Ex: Adam, Bob, Cindy, Dave. When I filter out two names, how can I get the name in Cell A1 that is on a different worksheet to show the name that appears the most. For instance, if my filter in...
    • Lecram
    • Thread
    • formula & text link cell most common text string
    • Replies: 2
    • Forum: Excel Questions
  5. B

    Return most common, 2nd most common, 3rd most common, etc. text string in an array

    I have a table of data [Table_CQI_Contacts_be.accdb] of which one column [Provider Name] has text strings. My goal is to write a formula that looks in this column of data and returns the following: Most Common Text String 2nd Most Common Text String 3rd Most Common Text String . . . 20th Most...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top