difference between rows

  1. B

    vba find two partial matching cell

    Hi i will be able to find two partial matching cell? For example: Cell 1 contain Apple Carrot Elephant in worksheet 1 Cell 5 contain Apple Banana Carrot drinks in worksheet 2 After that it will output the difference next to cell 5 of worksheet 2 C2 contain Banana drinks in worksheet 2...
  2. D

    Subindexing and Marginal Differencing

    I have this dataset: <tbody> User Date Time A 9/1/2019 8:00 AM A 9/1/2019 10:00 AM A 9/1/2019 4:00 PM A 9/1/2019 5:00 PM A 9/2/2019 8:00 AM A 9/2/2019 5:00 PM B 9/1/2019 9:00 AM B 9/1/2019 3:00 PM B 9/1/2019 5:00 PM </tbody> The first thing I want to do is add a subindex on...
    • dfdsiii
    • Thread
    • difference between rows help ! index margins power query
    • Replies: 1
    • Forum: Power Tools
  3. T

    Formula to calculate difference between values.

    Hi all, I need a formula that will allow me to help calculate the difference between a value and the next value upwards. so for example as per the table below Megans quarterly billings are 12,458, i need a formula that will calculate the difference between this value and the nearest value up...
    • temiomadeli
    • Thread
    • difference between cells difference between rows subtract rows
    • Replies: 11
    • Forum: Excel Questions
  4. M

    Find Differences in Two Lists

    Page 295 and 296 of Power Excel with Mr. Excel. The tip utilizes the Go to Special - Row Differences command to highlight differences in the two lists and repeatedly pressing F4 to highlight differences in different columns. Problem I'm having is that I cannot get this tip to work. Thought...
  5. S

    Calculate difference in pivot table

    My database is a set of dates, products and sales values. I created a pivot table like this: <tbody> Product Date1 Date2 (DIF????) A 100 120 B 80 90 </tbody> I am trying to set a column to automatically calculate the difference between the two dates, without sucess. My first try was...
    • Sullivan
    • Thread
    • calculated field dates difference between rows pivot table
    • Replies: 1
    • Forum: Excel Questions

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