previous

  1. M

    Copying rows based on a matching date

    Hi All, I've found so many variations on how to do this, but none seem to fit exactly what I'm after so I'm getting lost in that spiral - so I would appreciate any advice/help. I have a spreadsheet that has several sheets. Sheet 'Calc_Sheet' contains a value in cell E1 which lists the last...
  2. C

    Make different calculations depending on current month

    Hi guys, Can anyone help me out sorting this issue i have? What i'm trying to is to get a formula that makes a calculation for all the previous months (this year and the previous ones). For the current month (and following months) the cell value will always be "". I've come up with this but...
  3. J

    Month is filtered and previous month are zeroed

    Hello, I have columns Jan-Dec 2019 with a IF formula already in the cells. I need to figure out how to enter a formula that can zero out the previous month when selected, but keep the rest of the years data. For example when I filter to Mar, the current data stays and Jan&Feb will equal to...
  4. X

    How to find a change in data

    I am familiar, to an extent, with index-match and is what I am using in my spreadsheet for most of the equations. My spreadsheet is using public housing data for my local community along with manually inputed data such as what school, what neighborhood, and if it is on the water or not. Every...
  5. M

    VBA Select the previous visible cell in a filtered table.

    Hi Guys, I'm trying the select using vba the previous visible cell in a filtered sheet. Dim rng As RangeSet rng = Range(Cells(ActiveCell.Row + 1, 1), Cells(Rows.Count, 1)) rng.SpecialCells(xlCellTypeVisible).Cells(1).Select ActiveCell.Offset(0, 17).Activate Here is a code I have that does...
  6. F

    VBA for copying and adding new cell value in every row

    Hello Guys, i need to execute this simple thing...pls read below A1 = 15 here a1 has cell value 15, so when I change it to 16, A2 should show number 15, when i change it to 17, A3 should show number 16, means whenever i update the Cell Value A1, the new row records the previous value and...
  7. U

    Conditional formatting based on previous 85 days...

    Assistance please - If one of my staff is absent I will put an x in today's column at the side of their name, I need that cell to auto highlight in red if they have had an x in the previous 85 days, this does not include weekends.
  8. IluvPivots

    Sum previous columns

    In search of a formula that I can populate across columns. Right now it looks something like this: In cell J7: =($B7*J$3)-I7-H7-G7-F7-E7-D7-C7 In cell K7: =($B7*K$3)-J7-I7-H7-G7-F7-E7-D7-C7 Every new column subtracts the sum of the columns previous to it. The number of columns will continue to...
  9. B

    Measure to count number of clients making higher payment than previous month

    Here is a dummy dataset to illustrate my question: <colgroup><col><col><col></colgroup><tbody> Client_Ref Start_of_Payment Month Payment_Amount 101 01/01/2018 20 101 01/02/2018 20 101 01/03/2018 25 102 01/01/2018 15 102 01/02/2018 25 102 01/03/2018 10 </tbody> I am wondering if...
  10. D

    Excel formula for previous year

    Is there an excel function for the previous year?
  11. M

    Formula: If condition is false don't change current cell value

    I am trying to create an excel sheet that keeps track of my teams progress throughout the week. I put an example of what I currently have below as well as the formulas. <tbody> Name Complete Total 12/31/18 1/1/19 1/2/19 1/3/19 1/4/19 1/5/19 Mike 9 10 =if(D$1=Today(),$B2/$C2,"")...
  12. S

    Imported Data Not Showing on Form

    I've imported records to a table to take the record count to 90,000. When I open a Form I have which has been used for the previous records (previously 48,500) it is only displaying the previous records and seems to be ignoring the newly added records. I added the records yesterday thinking it...
  13. C

    Need help with VBA code?

    https://drive.google.com/open?id=1k8QjVO4PLCvDd_699xf0qXIXNZ5XygbC Hey guys, I downloaded an excel sheet online and try to modify it but I am having trouble with it. I added column now the No. of days is now started in day 3 instead of 1 and also when I click on another month I want the previous...
  14. X

    Getting previous 10 workdays (excluding weekends) from Today (vba)

    I am working on a sheet which requires previous 10 working days from today: Something like this: <tbody> 10-Dec 11-Dec 12-Dec 13-Dec 14-Dec 17-Dec 18-Dec 19-Dec 20-Dec 21-Dec </tbody> i am scratching my head from last 3 days with all kind of wiered loops but nothing is working. Can anyone...
  15. J

    How do i copy values from the previous sheet?

    Hi, i have the following ActiveCell.Offset(0, 0).Range("A1:C500").Value2 = ActiveCell.Offset(0, 0).Range("A1:C500").Value2 how do i modify this to copy values from previous sheet instead of current into same range if it helps, the sheets are labelled as weekly dates (dd-mm) 26-11 03-12 10-12...
  16. T

    Return records from multiple date criteria

    I am trying to create a query that returns a list of clients that were in a placement at any point during a month. The SQL below will return the list for the previous month but I want to get the lists for each of the previous 12 months all in one query. I've thought about just making a query...
  17. Trevor3007

    date & time stamp

    good evening, i have to time\date stamp every entry placed in a worksheet. Is there a way to use =now() so when a new entry is done , any previous wont update to the new time\date? MTIA Trevor 3007
  18. A

    VBA-Transfer data to anothe sheet

    How to transfer data from different columns from sheet to another without delete the previous in another sheet
  19. D

    Previous Month

    Hi, I have a data validation list of Months (Jan to Dec in three-letter format) - Jan, Feb, Mar, Apr etc. But I am looking to have a formula which in the next cell fills in the previous month (in the same format) to what I have selected from the drop-down. Is this possible? Cheers, Dougie
  20. S

    IF formulas working in all but one cell/column

    Hi, I have a budget template that has IF statements to exclude costs bases on the max allowed ($25,000) and the previous years' totals. I have 4 groups of these per year for 6 years and all the IF statements appear to be set up the same and work in all but one of the groups and I can't figure...

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