prior

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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