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