ignore cell

  1. U

    How to ignore multiple cells from drag and fill or enter any formula

    Hi guys when i drag and fill, i want skip 2 rows and force not filling 2 rows (2 rows are in every page and i can't insert any formula beacuse in my workbook, all cells filling with a formula) anyway ignore this 2 rows in every page when i drag and fill? (for example i drag and fill 34 cell in...
  2. S

    For Loop to Change Cell Colors and Ignore Cells Based on Color?

    Hi everyone, hoping for your expertise. I am working with a set of data and trying to create a macro that, based on the cells that are selected, will return the highest value with the first button click, the second highest value with the second button click, etc. I have put together the below...
  3. dynamimic

    vba - how to ignore current cell before proceeding through Loop

    Hi there, vba virgin up until last week, but I'm trying to teach myself, so please go easy on me. I'm trying to create an Excel loop which will color rows blue meeting a certain criteria. My subroutine works, however, it always first colors the currently active cell blue before running through...
  4. S

    Concatenate a range but ignore any cell with 0.

    Hi there, I'm concatenating (is that a word?!) a range of data into one cell using the =CONCATENATE function. However, I want the function to ignore and skip any cell which has a '0' in. for example, data: A1= 7 A2= 0 A3= 9 A5 =CONCATENATE(A1,A2,A3) I want to see A5= 79, but have A5= 709

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