prior

  1. S

    Select Random Sample from Prior Day with Specific Criteria

    I apologize for a duplicate/similar post, but my prior post was not answered correctly/sufficiently. I have a large data set, with 22 employees that tracks their daily transactions. I want to obtain a random sampling of 1 transaction per person from the prior day. Column A = Transaction Number...
  2. H

    Macro to filter dates and tdelete those rows

    I have dates in Col F on sheet2 I have manually filtered the dates prior to 01/10/2017 (dd/mm/yyyy) and then manually deleted the rows I would like to automate this process so that a message will appear "select date you wish to filter prior to this date" once this is inputted , Col F must...
  3. A

    Return value to a weekday closest to certain date

    Hi, I’m trying to return salary (from one cell) in to a cell next to the 28th (calendar as list) or Friday prior to the 28th if the 28th falls on weekend or bank holiday. Any help greatly appreciated. Thanks
  4. T

    VBA for moving entire row based on cell value to another worksheet

    Hi, It has been 8 years since I have dabbled in Excel macros. So I need help! I am using the Excel for Auditors 2007 Edition so maybe that is my issue. I have a report that list Reps in column G. I need to loop through all rows on the sheet, create a worksheet based on that value and move the...
  5. M

    suppress dialog boxes vba NOT applicatoin.displayalert = false

    Here's my code: aggregate = "'" & ThisWorkbook.Path & "\" & counter & "\[aggregator.xlsm]" & ws.Name & "'!percent" prior = "[" & counter & ".xlsm]" & ws.Name & "!" & counter & "MBO" If counter = qt Then rng.Formula = "=iferror(" & aggregate & ",""oddly...
  6. Y

    Date Range - Count Days per Month

    Hi, I am seeking a formula to calculate the days per month assigned to each job. For example job 1 is 98 days and the formula automatically assigns the 98 days across the Prior Year (2017) and Jan-18 to Mar-18. Similar formula for each subsequent job based on the start and end dates of each...
  7. M

    Excel VBA - Open monthly file names based on Month being worked on

    Hello, I need some advise. I want to automate some data entry in excel. We have a spreadsheet where data is manually entered into cells E15, E16, F15, F16, O15, O16, P15, P16, Y15, Y16, Z15, and Z16. Row 15 is for current month data and row 16 is for prior month data. There are two files...
  8. M

    optionbuttons should work dynamically

    Hi, There is userform with two optionbuttons that depending on the selection are shown as FALSE and TRUE in cells A1, A2. The issue is those optionbuttons selection should result in dynamic changes in A1 and A2, prior to userform closing. How can I fix it...
  9. D

    Using a Formatted Date in a Formula

    Searched the archives but I could not find an answer... I have a cell with a formatted date entry (MM/DD/YYYY). I need to use the DD to calculate an average per day where the data I am using is thru the prior date: F3 = (B3 / (DD-1)) What would be the correct way to write this? Thank you...
  10. P

    Need help with a formula that will give me the average of the prior 4 weeks

    My data set is as follows: In columns starting on C3 I have week ending dates starting with 1/6/2018 all the way to column BB3. on Column C5 i have the week number starting at 1 going all the way to column BB5. C6:M6 contains my data. I need a formula that will average the prior 4 weeks. I need...
  11. J

    Calculate items sold within 10 days prior to specified date

    Hi all, I have a list of sale line items, one column has a date, the other the number of items sold. How can I sum number of items sold, where order date is <2/12/18 and >2/02/18 but instead of inputting the date, I would select a cell containing 2/12/18 (i.e E3) and tell the formula to look...
  12. Y

    2017 active employee by month

    I have a sheet the has employee names in column A. Column B contains their hire date, which could be 2017 or any prior year. Column C is termination date, which could also be 2017 or any prior year. Column D is re-hire date. Columns E-P are months Jan - Dec. What formula can I use to...
  13. E

    Sos!

    <tbody> Latest Recv Date 2017 2016 2015 2014 & Prior </tbody> So I have a col G with a Date (Any date from 2012 to 2018). I need it to read such that,if the date in ColG is 2014 and prior then the value from Col Q goes into ol Y(2014 & Prior), else returns 0...
  14. E

    excel If date is after or before 5pm the prior working day

    Excel dates. I have a date of job and date/ time of job request. If the job was on a Monday, or weekend I need to determine if the job was requested before or after the previous Friday at 5pm. The rules are if a date of job (Job date) was requested (job requested date) after 5pm the prior...
  15. P

    Bring the first date prior to a date

    Hi. I have a column (A) with dates sorted by oldest to nearest. I also have another column (B) with dates but with gaps of 4 or 5 weeks between them. I would like to have a formula on another column that will bring me the first date in column B if that date is prior to column A. An example so...
  16. K

    countifs with multiple criteria in the same cell

    I have data in column W that has multiple answers to a question. Example (A, C, or A, H, or B, D,). I'd like to count all the As with a date equal to or prior to 10/1/17. I tried the formula below and know that I'm missing something but just not sure...
  17. A

    Optimization Possible for Calculated Subtotal Insertion VBA?

    Hello Folks! So I have this wonderful file that organizes project process by state / company, and one of the macros I run that I had assistance putting together a while back inserts calculated subtotal rows on every individual State's worksheet. The only problem is that it takes 12 minutes to...
  18. P

    VBA to Open Prior Month File and Copy and Paste Info into Current Month

    Hello, I have a monthly file that we have. I have code that asks the user to open the prior month's file, but I'm not sure what to do after the file is open. The file name will change every month (name of month is in the file name) and each month there is a YTD, MTD and QTD. But essentially, I...
  19. S

    nested if statements

    I am trying to write a formula that will look at a date in column H2 and determine if that date is a prior week, week 1 or week 2 For example anything older than or equal to 8/19/17 is prior, any date between 8/20-8/26 is week 1, and any date between 8/27-9/2 is week 2. I have it already done...
  20. A

    Does VBA Exist In Excel That Allows One To Hover Over A Certain Colored Cell and Make A Small Pop Up Text Box Appear With A Value On Another A Hidden

    Hi, Excel Genius Type Persons! :) This is perhaps pie-in-the-sky stuff, but over break a thought occurred to me that would be ever-so-amazing if it were possible, so I figured it would not hurt to ask!!! Let's say I have conditional formatting in my excel file that fills cells with orange and...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top