previous

  1. J

    Return value based on previous month

    Hi, I have a table that is a1:a13 Jan - Dec, then below each month are values, I want to add a column for each row to show the value for the previous month from today, so if its October today then return each value for September, then I can create a chart based on the previous month when...
  2. K

    Running total

    I am trying to make a sheet that has a column with a running total. However if nothing has changed from the previous day meaning the total is still the same as the previous day I would like to not add anything to the total but if possible still display the current total in that cell.
  3. L

    Indirect formula adjustment to previous cell

    I have the following: P18 = 15 P21 = D16 P22 = INDIRECT("D"&16+$P$18) P23 = I would like P23 to get the value 15 ekstra rows further down from the value in P22. So it could be INDIRECT("D"&16+2*$P$18) or something similar and possible to copy the formula further down (P24, P25 etc) so it...
  4. J

    Changing cell colors base on previous cell values

    Hi I have been researching this for a while but still can't seem to get my head around this. I have an excel sheet that does the following: <tbody> A B C D E F G H I 1 P1 + P2 P1 P2 2 70 20 50 3 139 70 69 4 139 50 89 5 </tbody> P1 and P2 have a...
  5. N

    Macro to transfer row if criteria is met or update

    Hi All I've been searching for a few days now for a macro that will copy and paste cells if a certain criteria is met. I also would like it to update any previous entries if change is made. The background is I have a workbook with 14 tabs and a "Master" tab. Each tab has 3 columns (D, E and F)...
  6. A

    Rolling Graphs

    Hi, I am trying to create an excel based dashboard for work in order to track performance on a monthly basis and all i have managed to create so far is a basic graph which updates when new data is added. What i'd really like is to have it just show the last 3, 6 or 12 months of data (without...
  7. N

    Insert a new row if the sum value is 250

    HI All, In column A I have numbers, need to add up the value in the column A and if the value is 250 then insert a row and in the new row need the total value of column B and in column Sum of column B multiply with 1.16. At time the sum of column A will not be exactly 250 in that case it has...
  8. S

    IF....., If....., If.......else VBA

    I am trying to create coding that will loop through column L (12) and if the cell contains the specific text or value then enter "Previous" or "Current" in adjacent cell in column M (13): "Error" = Current "[Rr]etro = Previous > 201814 = Current all other cells = Previous Dim f As Long ' for...
  9. K

    Formula Change on MS Query Refresh

    sorry for the dodgy title, didn't realise i hadn't finished (Should be "Formula Change on MS Query Refresh") Hi, I have just been given a windows 10 PC with Excel 2016 for testing. I have a problem with a spread sheet that has been working for years. in its simplest form: A5:G100 containers...
  10. T

    Sumifs with different column

    Dear all, I need to found the formula to obtain the sum of previous prices month in the column total. Let suppose we are in March 2018 and the month is not finished then you need to compare your current data to the previous and current year month by month. In the column "H'' I need to find...
  11. S

    How to get AVERAGE of 3 previous sheets automatically when you create a new sheet

    I am trying to get AVERAGE of 3 previous sheets of the same cells to the left of the last sheet on a workbook every time I am creating a new sheet. Can you do this by formula? I feel like you can't do this unless you manually update the formula each time you create a new sheet. Does anyone know...
  12. S

    Using IF....Else IF

    I am trying to get a loop to return a value (Previous or Current) when looking through a column. My coding is returning "Previous" when it should be "Current" and vice versa. Also, I am trying to get it to return a value (Current) if a string of text in a cell contains the word "Error". So if...
  13. E

    2016 Essbase Add-On Issue

    Hello... I am wondering if someone can help me please. We were just upgraded to 365 and one of my coworkers cant right-click in any Cell.. I knew how to remove the secondary button option off the Essbase Add-On for the previous versions, but I dont see that option now. Is there something else...
  14. B

    Getting a previous Monday (unless the date is a Monday)

    I saw a thread that asked for the prior Monday formula, but i used it and if the date is a Monday it goes to the previous Monday, How would i change the formula to be if Monday is today then leave it. I am new to using days of the week formula, so any explanation of how the formula breaks down...
  15. K

    If row is less than last row

    Hi guys Struggling with a little problem here, should be really simple you'd image, but danged if I can get it to work:- this below, is basically the idea I need to happen. If column A suddenly goes lower than the previous value, increment column b by 1. Can't use scripts. 1 | 0 2 | 0 3...
  16. K

    Double quotes x2 meaning

    Hi guys I'm fixing a number of excel sheets here atm. Unfortunately the original designer isn't here anymore. I keep stumbling across, what I think might be code, from previous versions of excel. Eg. =CONCATENATE(MID(C4,FIND(" ",C4)+1,1),"_",$N$8,$N$9,IF(G4 = "","",$N$10),IF(G4 =...
  17. Small Paul

    Save File With Previous 'Month' In FileName

    Hi All I have been working on opening/saving files using previous day. I now need to 'save' a workbook with previous month in the filename. The code I have is based on what has worked before: Sheets("Monthly CAC Report").Select ActiveWorkbook.Names.Add Name:="Locator", RefersToR1C1:= _...
  18. LVExcel

    Flag Backorder Shipments

    Hi Everyone, I'm trying to get a cleaner formula to label any records shipped as backorder. Here's my formula, but know there has to be something cleaner. =IF(AND(B2=B1,C2<>C1),"Backorder",IF(AND(A1="Backorder",B2=B1,C2=C1),A1,"Regular")) Formula: if Order# is the same as previous Order#, and...
  19. B

    Userform buttons

    Thanks for taking the time to read my thread. I tried to create a simple userform but i'm having trouble scrolling through it. Would I be better off creating a recordset? Some of the data is shown in the form and some is submitted. I'm trying to move forward, backwards, first record and...
  20. F

    userform textbox data append

    Does anybody know of a way to only append data to a text box. In other word prevent the editing of the previous data and allowing only new data to be entered. Thanks

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