strong

  1. O

    Create a new table without empty data rows

    Hey all, I asked a few weeks ago something like that, but now I would like to upgraed my question. I have a big data base (In range A2:P12), I would like to create the table in range F14:I17, The Cell F14 is a data validation list with all metrials. The table in range F14:I17 show only the...
  2. O

    A formula that shows only the list with non-empty values

    Dear all, I have a table (I have added a table with pictorial values) with quite a bit of data, under there is another table divided by countries with INDEX and MATCH, as you can see not every country has values, I would like to have only non-empty countries in the list. According to the...
  3. D

    Edit String dependent on first word

    I'm trying cut all the words of a string except the first one and paste the resulting "new" string in the cell where the old one was. This is the code I came up with so far: Sub CECorrect() Dim i As Integer Dim s As String Dim indexOfString As Integer Dim finalString As String For i = 4 To...

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