based on

  1. P

    IFERROR formula help

    Hi All I have a column (in sheet called worksheet column E - starting in row 2) with all names, including duplicates. I wish to make a list in a seperate sheet in column A with only the unique values (each name once in this list - starting in row 6). This list must also look at the value in...
  2. P

    Hide cells if month different from previous cell

    Hi. I have searched but didn't find anything similar. Found some posts about dates but nothing like what I am searching for. My question: We work with a worksheet to register quality issues occurred during a certain month. The sheet is printed out a few days before the start of the new month...
  3. B

    Conditional Format based upon another cell

    Hi, I need some help. How do I place a conditional format for one cell that is based upon the value of another cell. i.e. - A1 turns red if A2 is greater than 2. Thanks, Chris.
  4. K

    Subtotaling based on date in a column

    I am trying to create a subtotal in Column L for the values in Column K that all have the same date in Column A. All of the Dates in Column A are in chronological order. No dates are out of order. Example A1 = 11/2/2008 : K1 = 22.00 A2 = 11/2/2008 : K2 = 25.00 A3 = 11/4/2008 : K3 = 12.50 A4 =...

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