recent

Can you build a formula to only pull data associated with the most recent date? Example: A1 - A100 has dates ranging from 06/25/18 - 08/11/17 I only want the data from the most recent date. This report will be updated everyday so I was hoping to have a formula that I can use everyday. Thank you

Hello I am having issues making the following formula pull in the most recent payment amount from another tab. =IF(H7=W7,0,IF(J7<=$A$1,IFERROR(LOOKUP(9.99999999999999E+307,SEARCH($A7,Payment!A:A),Payment!P:P),0),0)) What I am trying to do in column V is if the amount in column H = the amount...

Is there a way, in Excel 2007, to remove just 1 entry from the Recent documents list? In my personal QRG for Word 2007, I have a note that says that Alt+Ctrl+- (minus) will change the cursor to a thick vlack bar, which can then be used to remove entries from menus, including the Recent...

Hello! I currently have a working macro that deletes all the rows that contain a date equal to or older than 6/1/18. However in coming weeks this date will change and I would like the macro to reference the most recent date found in a column E of a sheet called "Current" in the same workbook...

We just upgraded to Excel 2016 - I cannot find the "open recent file" icon for my quick access toolbar. Is it no longer available in Excel 2016??

Hello, I'm doing a step challenge at work and we've been put into random teams. My team wanted to have their own league so we've set one up but its based on total steps. I've been trying to make a sheet which I can add the total steps at a specific point each week and automatically calculate...

OK -another golf spreadsheet question! :) I want to take the most 6 recent weeks for handicap but having trouble with an efficient way to do that. It has to ignore any blank cells too. There will be 20-21 columns and want column B (A for name) to be a running most recent Handicap average of...

How do I use vba to look down a column of dates and if any dates = a Friday choose that date, if not choose most recent date.

Is there a way to calulate a DATE+1+HOLIDAY for dates in several columns and return the most recent date from all the columns? COLUMNS THAT I HAVE DATES IN: O S (don't add the 1+HOLIDAY to the dates in this coulmn) U AA:AF

I am using VLOOKUP to import dates from another sheet into Columns U – AV. These columns are formatted as mm/dd/yyyy. In column V I am using the =MAX function to return the most recent date in column U-AV. Since ALL cells in column U-AV are not populated with dates. They are showing as...

I built a golf handicapping sheet for my league of 30 players, each player has a row for score entries for 100+ rounds. Each week I enter into row A Frank's score, from A1 across. If Frank doesn't play that week, the entry is "0". Row B contains formulas in each cell from B1 across that look...

Morning all, I have the following calculation in my sheet :- =IF(AT154="","",MAX(AT154:CI154)) if there is a date in present in AT154 then this formula will look along that row and in cell AJ154 will return the value of the most recent date in that row. However we have now started to...

An excerpt from my data is below. I need to evaluate: the account #. If it repeats in several rows I need to Evaluate the case #. If it repeats in several rows I need to Evaluate the status date and FLAG only the most recent (newest) date when the account # AND the Case # are repeated. I...

Excerpt from a sheet of data is below. I need an if statement that will evaluate several data elements and flag the most recent date when selected criteria are met. I can then do a simple data sort or pivot table and isolate only the most recent status dates and statuses IF the account # and...

I'm having some difficulty with an INDEX, MATCH, MATCH setup. I'm usually pretty good at figuring out how to make these things work after some tinkering but this one has me stumped. I have two Sheets laid out similar to the following. <tbody> NAME Recent ON Recent OFF Item 1 Item 2...

Hi, I have alternating columns of Date 1, Amount 1, Date 2, Amount 2, etc. corresponding to a record in column A. I have this setup as Date 1 (H6), Amount 1 (I6), Date 2 (J6), Amount 2 (K6) etc. I want to be able to see the most recent date and the corresponding figure from that date. So far...

Hi guys, I would like to create a query that will deliver: 1. KRI_ID 2. DataDate 3. KRI Value The difficulty is that I would like it to bring back each KRI_ID only once - only selecting the record with the most recent date available by using the DataDate field. Any idea how I can get the...

Can anyone show me how I can keep the most 10 recent files in a folder and delete the rest? Additionally, I need this to only apply to files with 'Test' as part of the filename.

I need a macro which could compare the dates between 2 sheets (which contains date in column A and other data like product, customer name etc. ranging from column B:F) I.e sheet 1 and sheet 2 and filter the most recent dates in sheet 1 which are not available in sheet 2 and copy the data...

Hi I have a list of hospital patients each with a unique Patient ID, a date of Admission and a date of Discharge. For each readmission I need to indicate if it happened within 30 days their most recent discharge. This is an example of what I am aiming for.... I have managed (in column D) to...