conditiona

  1. J

    Conditiona Index/Match Statement Help

    Hello: I have the following formula =INDEX(CCMSTime!C:C,MATCH(A2,CCMSTime!A:A,0)) Works great, except when there is nothing to return I get the following #N/A, which causes problems when I am trying to do SUM How can I rewrite my formula so that if there is nothing to return Excel places a 0...
  2. T

    Conditional Formatting with dates

    Dear all hello, I am trying to add conditional formatting in one of my columns as follows: 1)when the date in column A passed the today's date and there is no date in column B - turn the cell red - i used the following formula:=A2<today() 2)when the date in column A is greater then today's...
  3. A

    Using 'Like; to meet multiple conditions

    Hi, over past day or so i've built a quite a like VBA script with the help of the recorder, google and searching this board. However i've now hit a wall. The script imports an ASCII file, sorts it then analyses the data, couting totals etc. The difficulty comes in the fact the the ASCII file...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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