cellsf

  1. S

    IF....., If....., If.......else VBA

    I am trying to create coding that will loop through column L (12) and if the cell contains the specific text or value then enter "Previous" or "Current" in adjacent cell in column M (13): "Error" = Current "[Rr]etro = Previous > 201814 = Current all other cells = Previous Dim f As Long ' for...
  2. S

    Using IF....Else IF

    I am trying to get a loop to return a value (Previous or Current) when looking through a column. My coding is returning "Previous" when it should be "Current" and vice versa. Also, I am trying to get it to return a value (Current) if a string of text in a cell contains the word "Error". So if...
  3. P

    What is wrong with this IF/Then/Else loop

    So, I want Excel to go through each cell in the column I and if the length of the cell contents is more than zero, go through the next lines and change the content accordingly... but if the content is not listed and still the length of the current content is more than Zero... just change it to...

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