previous cell value

  1. P

    Calculation based on previous transactions

    Hi, I have a problem to solve. I have a data set of 7000 transactions and I need to calculate the amount for each transaction as per below formula. Please note that calculation will be done basis of account number. <tbody> Account Number Value Percentage Amount ABC 1000 0.1 =(B2)*C2-0...
  2. H

    Store a cells previous value

    Hello, I have a spreadsheet populated with data and some pivot tables, this then feeds a widget on a dashboard with a total. My widget has the ability to calculate the % up down and change its background colour accordingly. How can I retain the previous total of a pivot table in the...
  3. A

    Keep Previous Value of Cell

    Hi there, I have two columns, let's call them Event Date (Column A) and Previous Event Date (Column B). I would like to implement some VBA code (or use formulas if necessary) that automatically keeps the previous value of Event Date and retains it in the adjacent cell for Previous Event Date...
  4. D

    finding previous cell value when there are blank cells between

    I am looking to put a formula using VBA code into all cells of a column(column B), which would populate column B only based on the value of another cell in column A. I am having difficulty referencing the previous cell up in a column to get its value when there are blank rows involved. As you...
  5. R

    Capture Old Cell Value - VBA

    Hi Everyone! I would really appreciate some help with this one. I am trying to hide a worksheet using the old value in a cell and then unhide another worksheet using new value in the cell. I want this event to be triggered by a change in cell "O11" (generated from a formula). I have tried...

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