data comparison

  1. J

    PowerBI Comparison between dynamic daterange.

    Hi Guys, I have "SalesTable" and If I select March 1st 2017 to March 15th 2017, it has to calculate immediate 15 days before data and show the % change. or If a user select 10 days of data it has to compare the immediate 10 days previous data and show the % change. Please help! Thanks &...
  2. P

    Coloring cells based on data from other sheet

    Hi, I have problem with this formula: Sub Cell_color()Dim MyWorkbook As Workbook Dim Matrix As Worksheet Dim Help As Worksheet Dim Data As Worksheet Set MyWorkbook = ActiveWorkbook Set Matrix = MyWorkbook.Sheets("Matrix") Set Data = MyWorkbook.Sheets("Data") Set Help =...
  3. S

    Any number in a column is greater than last one entered

    Hoping someone can help me with this one. I've tried the COUNTIF and the IF methods I could think of and I can't figure how to make a simple formula I can put into the cells of a column that will do the following: Consider that Column E needs to contain a list of dates. 1. I need a formula...
  4. T

    flag or highlight when number entered exceeds a set value in relation to previous cell

    Okay, don't know if that Title will do it. However hopefully someone can help me with the following. I think it is conditional formatting that I want to use, but it doesn't seem to be quite right. I have a row of numbers and I want to have the system notify me or colour the cell or in some way...

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