ignoring empty cells

  1. N

    Finding Most Common String, then 2nd Most Common String, etc, in a Column

    Here is my problem, I am trying to calculate the most common string, the 2nd most common string, up to the 10th most common. Here is some of the data: FVHA FVHA FVFA FVMV FVBU FVHA FVHA FVFA FVBU and many more. Here is an example of the formula for finding the most common...
  2. T

    Vlookup and when to stop

    I have created a list of part numbers, and am using a drop down screen to select part numbers (nearly 500). In the second and third column I am using vlookup so that I can get prices, which I want to total at the end. However, if I copy and paste the vlookup formula to a maximum of say 20...
  3. T

    Blank Cells and LINEST

    I have been trying to use LINEST for the analysis of a large sets of data but have just noticed that this function does not allow for empty cells in the data set. Apart from the tredious possibility of removing the blank cells (which is not really possible for the large quantity of data...

Watch MrExcel Video

This Week's Hot Topics

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
Top