most common

  1. Y

    Find the value that appears the most

    Hi, On a tab I have the information below. Loc Model E76 WS-C2960G D71 PROLIANT DL360 G4 E76 PROLIANT DL360 G7 E76 PROLIANT DL360 G7 E76 PROLIANT DL360 G5 A80 PROLIANT DL360 G5 When I am looking for the value which is link to the value E76 I get WS-C2960G. But I would like to...
    • yoan6
    • Thread
    • index index and match match most common
    • Replies: 8
    • Forum: Excel Questions
  2. G

    First, Second, 3rd, 4th, 5th, 6th most repeated TEXT

    <colgroup><col></colgroup><tbody> I didn't find any formula to return most common text from 1st to 101th or even more places. ALWAYS DATA IN VERTICAL COLUMN SIMPLY AS POSSIBLE <tbody> <colgroup><col></colgroup><tbody> Naturaleza asociada ÁRBOLES FRONDOSOS JARDINES SOMBRA FRESCO...
  3. M

    Stuck trying to get common value, please help

    Here is what I am trying to accomplish, I have two columns column "A" has many different numbers and column "B" has different prices associated to column "A". I am tring to find the most common price in column B as it relates to A without using a pivot. EXAMPLE 1 & 2 of result desired below. As...

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