ago

  1. G

    Recording changing cell

    Hi guys I have been struggling to find a solution to an excel problem I have. As the title says I have a cell in my spreadsheet that is constantly changing "H10" and I would like to record this for the last 5 seconds at 1 second intervals. But this would be triggered to start recording with...
  2. R

    Compute data in other cell if cell is blank

    Question: How many employees were promoted more than 7 months ago (Column C)? If they were not promoted, then how many employees were hired more than 7 months ago (Column B)? <tbody> Employee Hire Date Last Promotion Date Employee 1 <tbody> 09/12/2013 </tbody> 01/01/2018 Employee 2...
  3. M

    Custom Date Filter in Excel

    Using Excel 2013, is there a way to create a custom date filter to filter all dates that are >90 days ago: >today()-90. When I type this into the custom filter formula, it isn't working.
  4. G

    Text to Date and time

    I've looked around and could not find the solution. I know I've done something similar before, but it was a long time ago. I need extract the date and time from the follow text string: Jan 6 2019 8:30AM Thanks
  5. J

    How To Select "Save As" From IE Download Dialogue Box Using VBA

    I realize that there are more efficient ways to obtain files from websites using VBA but I really want to figure out how to control the Dialogue Box that pops up when a user is trying to download a file. To be more specific, I want to select "Save As" and set the file destination. The...
  6. K

    Formula to find % for times a date is under 6 months ago

    Hi all, I am trying to evaluate if a column on another sheet in the workbook’s date is less than 6 months ago and count them all up when the value (in this case it’s a person’s name) in one of the columns = the value I am looking for. I then what to split out the percentage of how often it was...
  7. D

    Count of data between 2 dynamic dates

    If I have a large amount of data (ticket volume) and need to know how many tickets were created between 0-30 days ago, 31-60 days ago, 61 - 90 days ago, and 90+ is there an easy way to do with a pivot table or do I need to change the date filter by 30 days and copy and paste the data for each...
  8. B

    Assigning scores based on how long ago something happened, stuck on formula

    I’m trying to use a bunch of if / and statements to work on the following problem but it isn’t really getting me anywhere. The premise of what I’m working on is that certain things have taken place in the past, and depending on how long ago it happened, it gets a certain score. - If it...
  9. K

    cannot view workbook information in locals window

    I put in the code: Dim wb As Workbook, str1 As String Set wb = ActiveWorkbook And when I look at the info for wb in the locals window for wb it just as no variables. I'm pretty sure that it was working a second ago.
  10. M

    Countifs more than 30 days old but less than 120 days

    I have a date in a cell on a table and I want to use countifs. I want to say count the number if records where the date (in date and time format DD:MM:YY HH:MM) where the date is over 30 days ago from today and less than 120 days ago where the status of the customer (colum M) is Sale completed)...
  11. R

    Excel Unreadable Content

    I have a workbook in Excel 2010 that after I use a sort macro when anyone reopens the workbook we get an error that says it has unreadable content. Then if you say yes we see a box that says. Removed Records: Sorting from /xl/worksheets/sheet1.xml part I never seen tis before until just a week...
  12. M

    Sheet suddently slow

    Dear All, I'm working a quite big process with a userform with 8/10 buttons doing different things on a sheet. The file il 1400 kb big and it used to be normally fast. Some weeks ago all the processes suddently slowed down but I can't understand why and i don't know where to start to find out...
  13. R

    If function with date

    Hello - I am looking for a formula that will return "A" if the date in B5 is equal to or less than a year ago, and "B" if the date in B5 is greater than 1 year ago So far I have: =IF(C5>=DATE(YEAR(B4)-1,B4,B4),"A","B") C5 is a date that varies B4 is today's date =TODAY() It returns: #NUM...
  14. R

    Extract length of time and subtract from date/time cell value

    I’ve been struggling with how to start and get this done. I have a column that contains a length of time that could be worded like: 53 seconds ago, 2 hours ago, 1 minute ago. Then I have a column that has the date/time the data was extracted. I need to be able to subtract the column that has...
  15. P

    Conditional Formatting Dates

    I need to conditional format cells where a date is less than today but no longer than 6 days ago. In conditional formatting, what formula do I use to achieve this?
  16. shift-del

    Friends don't let friends copy quotes

    Hi, there is a duplicate in "Excel Thought Of the Day" but with different sources. Today: "Friends don't let friends merge cells." Tom Urtis A week ago: "Friends don't let friends merge cells." Jon Acampora :eeek: So, who shall be known for this grand quote?
  17. M

    Looking for a Vba count solution

    Hello, Can somebody please help me on using a Vba count method of solving the following. I'm attempting to get a football stat of how many games ago a team last Won Drew or Lost. Column A2 contains the first team and the range of B2:AU2 the results (B2 is the most recent result) at the end of...
  18. P

    How many days ago was Monday - this week

    Hi, I’m building a dashboard and have last weeks numbers (5 days of data) and I need to compare it to this weeks based on the day of the week we are in. Example, 500 tickets last week This week is Wed, so based on average we would have 300 tickets up to Wed. I need a formula that looks at...
  19. M

    Display CF Icons (based on date) Except when Status = these text values

    I'm trying to use Icon Sets to indicate the 'Age' of the last update made to the file but only want to display this 'Aging' icon when the Status IS NOT certain text values. Here's some sample data: a b c 1 Date Updated Status Icon 2...
  20. B

    How to run Excel 4 macros

    How do you run and Excel 4 macro? I've used the Get.Cell function before in the name box but I haven't used any of the others. Are these used on the old Excel macro worksheets? I think I exposed to the macro sheets years ago when I was using Excel 95 and 97 years ago in the early 2000 but I've...

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