latest

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

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

Hey guys, I'm new to the VBA code thing...still in the record macro stage!! I need assistance. I have a worksheet that contains 6 columns, A: Section B: Machine C: Component D: Severity E: Comment F: Date. Now I need a VBA code to filter by the latest date.:confused::confused:

I have a range of dates formatted as 'dd/mm/yyyy' and I'm trying to get the latest date using this formula; It's not working though - it has given me the latest date as '31/08/2018' when there are other cells with dates as '15/09/2018'. I've checked that the range is referenced correctly and...

I am trying to do a comparison between the latest and previous file in a folder. I can pull the latest file in the folder easily, but is there any way to filter to the second oldest (by create date) Thanks for assistance

As what the title said, if column "I" month shows the latest month which is month "May" Make column "H" filter out only data month with "May" only... :eeek:

Hi Team, Can any one help me in here with syntax please !! i have one Tab (Latest Pivot Tab) with Pivots and for it the Data is in another Tab ex:- (1st Month Tab) and for next month, i just have to update the Data in another Tab (2nd Month Tab)... Here the Same Pivots in the (Latest Pivot...

I want to know the latest payment date based on the criteria(customer code). I am now using this formula =MAX(IF(Table5[Customer Code]=C5,Table5[Payment Date])) and also CSE. Customer code Latest Payment C5 I5 C6 I6 only the first...

Hi, I have a sheet which shows the dates tasks were allocated to different staff members. Can anyone help with a formula that would show the most recent date a task was allocated to each staff member (should also show where the task was allocated to more than one staff member). Using the...

Hi! I have a code but it doesn't do what It should :D For h = 0 To k 'lets suppose from 1 to 4 capital = 400 * 3 ^ h ossz = 0 + capital Next I would like to sum up 400, 1200, 3600, and 10800, but the "ossz" variable is always the latest value of capital. So at the...

Hello World! Can some help me? How can I get the latest date on the following data?But if there's a blank date it should be blank. I did the MAX IF for the latest date, I just don't know what to do on the condition if there's a blank date. I would really appreciate your help! Sample data...

Hello all :) My boss stores the quote template in a folder. Each file in the folder is named the same except for a R and revision number at the end of the filename, ie...R1, R2...etc. The current revision if R19. I have a macro button that opens the latest template but I have to manually...

Hi All, I have assign x = TxtProjectID.value (text box) x value are in another workbook called "Timesheet Data" in Col E, with same directory. x = numeric data. I have multiple rows in "Timesheet Data". this x value information may exist multiple of times. What I'm trying to do... The...

Hello, guys! I need your help on one project. <tbody> V1 V2 V3 V4 V5 V6 12-Apr-2018 13-Apr-2018 14-Apr-2018 15-Apr-2018 16-Apr-2018 17-Apr-2018 </tbody> Let's assume V1, V2, V3, V4 cells are color filled with green, others are not. And I need to find the latest date from that colored range...

Down column C I have a list of names. Down Column B I have the date the names were entered. The list will have duplicate names. I need a formula that shows which duplicate is the latest entry. I want to use this formula in a nested formula. Basically an IF formula that says if this is the...

Need a Vba code to obtain the rank for the latest date and car type. EG find the latest date from today() for each car then obtain a rank. if the car changes the rank starts from 1 again. so In theory the latest 25 dates for each car. <tbody> Car Date Rank Volvo 01/01/2018 2 volvo...

Hi, I have a question with finding the latest date using Index & Match function with 2 criteria. In the list of table, there are repeated row of entry that matches this 2 criteria, but I needed the latest date. Base on the my formula, it always give me old dates...

Dear Excel Wizards, Currently I have a workbook that I use for record keeping everyday. There are many columns of data in this workbook, one of which is a date column. As I find it incredibly cumbersome to individually populate every single cell in each column as I move down the rows, I have...

Hello ! I have a following formula here. I am trying to keep track of the latest transaction made. This is an Array Formula entered with Control+Shift+Enter. =MAX(IF($B$1:$B$4=$A8,IF($C$1:$C$4="Cu",$A$1:$A$4))) =MAX(IF($B$1:$B$4=$A8,IF($C$1:$C$4="Dp",$A$1:$A$4))) <tbody> A B C 1...

Hi, Just to let you guys know my knowledge on excel vba is average. I have always used this forum for help when required and it has been great help! Now I am stuck with this. Please help! My excel has many more than 25 columns. I am trying to demonstrate using 4 columns here. 1st column = File...