previous cell value

Good evening, hope someone can help. I am trying to create lambda functions that work in various tables in a workbook. The worksheet calculates "Year To Date" (a running total) and "Previous Year to Date" (YTD from the previous row) The functions are kind of long (especially the Previous...

Hi All, I'm looking to return the value of of the last entry in a range. I've attached the sample here My data range is C5:I15, and my return range is D2 Basically when I enter data into my data range, I want that data to appear in D2. So, D2 is always the value of the previous cell. Seems...

Hi Gurus, I have a table of values that I would like repeat in a new column only if certain condition is met. In this case, Column 1 has the values, Column 2 has the condition On=1, Off=Blank. Id like column 3 to have values equal to column 1 if column 2 is blank and while column 2 is on=value...

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

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

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

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

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