common value

  1. Q

    Finding Most Common Values in Dataset

    I'm trying to find the most common values in a set, where multiple values can occur in each cell. I have a series of values organized similarly to the list below ex.1Apple Orange|Pear Apple|Pear Apple|Orange|Pear Watermelon|Pear Apple|Pear Strawberry|Orange and as a second example: ex.2Apple...
  2. R

    macro button action, copy info from another workbook, and display in anotherworkbooks merged cells

    I have 2 workbooks, Book1 and Book2. on Book2 I'd like to click a button that will copy info from Book1 and paste it ito Book2's "Cover" sheet. In Book1: the info that I want is in column E. This info is 0 to 20 five digit numbers (concatenated from an earlier action), all separated by at least...
    • Raceman
    • Thread
    • 2 workbooks common value concatenate copy and paste macro
    • Replies: 0
    • Forum: Excel Questions
  3. C

    Searching Dynamic Range for most common value while ignoring text strings

    I have an excel workbook that has several sheets. One of the sheets is named “Data” which contains 2 columns filled with latitude and longitude values. The latitude column is a dynamic range named “LatitudeSeries”. The longitude column is a dynamic range named “LongitudeSeries”. The...

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