previous

  1. K

    Rolling Filter for Table

    I have a table that is filtered by monday dates to pick up the current monday date and the previous 10 mondays to create a rolling summary. I am wondering is there any way I can setup a dynamic filter so it always picks up the previous 10 weeks each monday rather than manually removing one date...
  2. H

    Subtracting time to produce time in previous day.

    Hi I would like to be able to subtract a combination of hours, minutes and seconds from a date and time. The resultant time may be in the previous day and that is where the problem is. For example : 10/08/2019 01:08:00 I would like to be able to subtract 1 hour and 15 minutes from this...
  3. S

    Graph for multiple staff by week number

    Hello, I've really tried to figure this out by googling and struggling. I have a database of drivers which is in order of week number 1 - 52 along the top and their MPG (miles per gallon) per week. (as below). I wondered is it possible to put this into a graph, ideally or some kind of table...
  4. J

    Search with Multiple Criteria and Validation of Data in Multiple Tabs (Worksheet) in a Excel Workbook

    Hi Guys, I am here as a new member of the Mr. Excel and I need anyone here that can offer any help with a function I need to develop for an excel report I am building: The purpose of Excel Workbook Report I’m trying to develop is to be able to compare two different progress period in our...
  5. S

    Find previous from last selected

    Hi all Can someone help me with the following issue: I have written a successful routine on the userform to find the last entry. I want then to go to the previous record until the user finds the one he/she wants and also be able to return to previous. I have separate buttons for previous and...
  6. D

    Sorting and deleting based on previous month

    Column J has a ton of ship dates listed as '5/20/2019 and '10/14/2018 and so on. How would I write some code to filter and delete everything but the previous months ship date. I run this report in June for May shipments, so I only want to see 5/*/2019 dates, but I run this everything so...
  7. N

    Up and Down arrow (and =) indicator when the value is more or less than the previous cell

    Hi I have a row of test scores and I would like to show in the same cell next to the score an arrow that points up if the score is higher than the previous cell and an arrow pointing down if it's less. If the score is the same either an = or nothing. Can this be achieved with conditional...
  8. H

    VBA Code - add sheet with previous sheet name and suffix

    Hi AllI'm filtering on column I and creating a new sheet to move the contents too. I need to rename the sheet as the previous sheet name with the criteria suffix. Could somebody help me please with the last part of my code? Thanks Range("I1").Select Selection.AutoFilter...
  9. S

    How can I make this spreadsheet work?

    I'm working on a spreadsheet which needs to populate info for an entire year. What I need the Total Meter Worked columns to do is if the end meter is a zero, to populate a zero. If the end meter has a number, then to subtract the end meter from the previous month. However, if the previous month...
  10. C

    Datepicker, Default to previous workday

    OK I have this in my code which defaults the datepicker to todays date but I have tried to no avail to get it to use previous workday as defasult date. I know this is gonna be simple but here is what I have now which works for today. PrevRptDate.PrevDTPicker.Value = Date I have tried a few...
  11. M

    Using a previous row's cell value

    I am struggling with figuring out the VBA code to use the cell value in the previous row in a formula. The formula is applying a simple filter to data from an accelerometer that is a little noisy. The data is in column format. Trying to create the equation that basically states...
  12. P

    Power BI two customized period not working

    Hi All, try to replicate the below but my both date and previous date can only slicer the sales amount not the previous sales (Previous sales does not change at all). Any ideas what went wrong and is there any other better way to do it...
  13. M

    VBA code to copy and paste between sheets based on the selection criteria being a date

    Hi All, I have a spreadsheet that has several sheets; Sheet 'Calc_Sheet' contains a value in cell E1 which lists the last date of the previous month in the format dd/mm/yyyy and is formatted as a Date field - *dd/mm/yyyy. I have another sheet 'Previous Month' that has all the data of...
  14. C

    Sum row cells based on previous cell value

    In my cells for example: Cell A1 A2 A3 A4 A5 A6....etc B 5 D 7 B 3 In the example above cells A1 & A2 go together such as if the value in A1 = B then I need the value in A2 which is 5. I need the value of the cells where the previous cell/cells = B In the example above, A1...
  15. L

    Run-time error '1004': Method 'Range' of object '_Global' failed

    Hello - I am trying to work out why I am receiving this error. When I debug it - the bold and underlined line below is causing an error. It may be worth mentioning that this works fine in a normal Macro enabled workbook. But once I upload the workbook to a collaborative tool, this error...
  16. R

    Rounding time to nearest previous interval.

    Hello Everyone, I am attempting to rounddown the time to the nearest previous interval. I have some data in excel. It logs the start time of a bar. Eg the 16:00 bar begins at 16:00 and completes at 16:00:59 Now when the time is at 17:20 I would like excel to look for the time 16:00 (starting...
  17. JazzSP8

    Populating two fields, but only display one field if there is a difference.

    Hey Guys I've recently started to use Access a lot more than I have previously and as such I'm trying to learn more about it and make some of my current processes in Excel more efficient by getting Access to do more of the donkey work. I currently pull in data Tables from Access to Excel in a...
  18. Y

    Calculate repeat sales

    Hi guys, I am running a table to estimate the amount of sales I can generate. <tbody> Jan Feb Mar Apr May June Unit Sold in current month 10 12 14 16 18 20 Unit Sold from previous months X Unit Price ($) 4 4 4 4 4 4 </tbody> The 2nd row is where I am struggling. I am looking...
  19. M

    create and rename Excel sheet as previous name +1

    HI How can i create and rename excel sheet in same workbook as per previous name +1 for example when we click on + sign excel add "Sheet2", "Sheet3" and so on but what about sheet name is "abc1". Now i press + then excel should create sheet "abc2","abc3" through vba heaps thanks in advance thanks
  20. D

    Find Previous Match

    Attempting to calculate Mileage difference ("D") by finding the previous "Fuel" event amongst a variety of events listed ("A") in order to fill in the missing data in Column "B" for the purpose of calculating MPG ("F") A, B, C, D, E...

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