latest

1. Complex INDEX MATCH - Now Add Max

Hi All I have a couple of Index Match formulas that are working well for me but I've realised there may be more than one result to find and I only want the latest date. My formulas sometimes have two match criteria and two index location, but I'm not sure how to return the highest valued...
2. Pulling Latest value for each ID via vba

Hi Guys, Basically I have a fairly large spreadsheet which contains ID's and then values in the adjacent column with dates in the following column. For each ID I want to take the value corresponding to the latest date, bearing in mind each ID could have a different number of values and...
3. Finding Date in Listview

Hi, Is there anyone that can show me how to find in listview control column 2 the earliest date and populate it in textbox 1, and the latest date into textbox 2. Thank you to anyone that can help me.
4. SUM based on 3 criteria but only the latest date - Excel Function

Dear MrExcel I have to find the value of the latest date, based on 3 criteria: Column A = range criteria 1 (A1:A10) Column B = range criteria 2 (B1:B10) Column C = range criteria 3 (C1:C10) Column D = range of the value/number (D1:D10) Column E = range of the date (E1:E10) A12 = criteria 1...
5. Return value based on latest date for entry

Hi I have a spreadsheet with factory name, review date and overall evaluation. Some factories may have multiple entries and reviews. I would like the overall evaluation to return based on the latest review for each factory. Therefore if i have a duplicate factory on two review dates and the...
6. Need help on Aging formula

Hi Folks, I have 3 columns wit different dates and i want to write a formula in 4th column and my condition is to calculate the aging whichever is the latest date among the three columns. Formula needs to calculate aging from =TODAY()- Latest among the 3 columns dates.
7. if combined with index/match (I think)

Hello - it's a while since my last question, but I'm totally stuck on this one. I have a sales database which includes multiple columns and my basic quest is to have a formula that establishes if a product has had sales in the latest week so a linked table can say listed/delisted. The latest...
8. Pivot Table how to show latest value in the period instead of sum total

I have a table like this Country, headcount, Month ================== US, 23, May2019 US, 24, Jun2019 UK, 27, May 2019 UK, 27, Jun 2019 Now pivot-table of Country as row and Month as Column, the Q2 column is showing 47 (23+24) for US. Is there a way the Q2 column be the latest value in the...
9. VBA to open MM_TEST in folder /subfolder

Hi , I would like to open a file ie MM_Test by DIR or FSO method by searching all folders and subfolders in Directory: C/Example/ The file names can also range from 01_TEST to 12_TEST. For example , latest would currently be 06_TEST based on June. So rather than date modified, is there a...
10. Latest Date

Good evening all, I am trying to identify what the last communications are from a large range/list of data All I need is "Latest Communication" if the date from C12:F12:10003 and job from F12:F10003 is the last entered or if the only one entered Each job may have been communicated more than...
11. Creating measure selecting latest date and time

Hi there, Im looking for help to write the correct measure to pick the price based on the latest date and time. A simplified version of my data set looks like this : <tbody> ID Price Time 21 15,2 21.05.2019 10:00 21 15,9 21.05.2019 10:10 21 15,5 21.05.2019 10:20 21 14,7 20.05.2019...
12. Formula to find latest & Old date from a column based on criteria

Hi All, I have 5 columns of data. In which A to D columns are text and E column is date. I need 2 formula in F & G column to check latest and oldest date in column E based on criteria from A to D Column. For example: In Column E I have dates from 2017 September( In 2017 I have only 2 dates...
13. How do I get a folder to open with latest file.

Hi I have a folder that has approx 14 workbooks in and a shortcut button on a different workbook . Im trying to find a way that I can click on the shortcut button and then it will go into the folder concerned and then open the latest file that has been created. I was advised that it poss...
14. How to return the latest column with a value - if D 0, go to C and return the date of that corresponding column

<tbody> 1 A B C D E F G 2 20/10/2015 10.5 19/10/2016 8 20/10/2018 8.2 3 30/1/2016 9.5 20/3/2017 7 4 10/2/2010 7.4 </tbody> Hello, I am trying to find the latest result of a blood test. I have two repeating columns in the data - the Follow up date and then the result...
15. Nesting IF statements/other solution?

Hi all, Long time fan of this forum, many times have found answers here without needing to post, but this one has truely stumped me and I cannot find the exact answer I need anywhere. I will try to be as brief and clear as possible. Any input is appreciated! Side-note: I read about a new...
16. Min/Max dates

Hello I have a spreadsheet COL A - contains a year COL B - persons name COL C - formula counting the number of years for the person named in COL B What I would like is to enter in COL D - the earliest year for the person COL E - the latest year for the person There can be upto 18 rows for...
17. Formula that matches multple criteria and pulls latest date value

Hi Mr Excel, I am currently looking for a formula that index matches multiple criteria (For example; Name & Course Name) & also looks for the latest date & returns the latest grade. Please see example attached below. I tried to make up an example on here but I am having a bit of trouble with...
18. [VBA] Create Hyperlink to latest worksheet in Workbook

Hey guys, as part of a larger macro, I want to insert a code that creates a link to the latest sheet of the workbook and name it according to the text in the selcted cell. This was asked in a simliar way before...
19. Keeping several instances of the same value

<tbody> Report ID Date 1234 11/16/2017 1234 9/26/2016 1234 10/11/2017 1234 8/15/2012 etc. etc. </tbody> Hello, See example above I have a large amount of data. Column A (Report ID) is duplicated. Column B (Date) is unique. I want to keep only the 5 latest dates and...
20. XLA File

Someone sent me a workbook to look at "because its no longer working". What they sent was an XLA file. They said it use to add a ribbon to their tool bar but now it doesn't work with the latest version of XLS. Is this just missing a tool pack or Add-in that needs to be activated in her latest...