# data comparison

1. ### 2 Tab Data Comparison & Update Help

I have 2 tabs where the first 4 columns have similar data sets. The 1st tab is the existing data. The 2nd tab is the new data (which may or may not be different from the existing). Essentially: I need to be able to update "Existing Data" with the New Data. Any new employees on New Data I will...
2. ### 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 &...
3. ### 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 =...
4. ### 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...
5. ### 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...

### 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.

### Which adblocker are you using?

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

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