latest

  1. C

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

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

    vba code for filtering by latest date

    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:
  4. sharky12345

    Finding latest date from range not working

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

    Power Query 2nd Oldest file in folder

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

    A macro to identify the month in another column and filter the data month in the other column.

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

    Changing Pivot Data Source to another Tab in same workbook using VBA

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

    Lastet payment date

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

    Display most recent date allocated

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

    Sum up the results inside a FOR loop

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

    Get the latest date but if there's blank the value should be blank

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

    Retrieve latest template from folder

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

    find record latest one

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

    Find latest date of colored cells from a range of colored and no fill cells

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

    Formula to tell which data is the latest in a list

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

    VBA? dates rank? possible?

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

    Index Match with 2 criteria and return latest date

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

    VBA for date logging

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

    If not found , set a specific answer instead of 1/0/1900

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

    Match multiple columns and retain the latest updated along with next related rows

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top