max date

Hi there, I am hoping one of you wonderful people can help me. The data within Lat! in column B has a few duplicates and I am trying to return a value from columns 34 & 49 where the date in AD is the maximum. Example data A1= 123456 Lat!B2= 123456 Lat!B3= 123456 Lat!AD2= 10/05/18 Lat!AD3=...

Hi all, I am trying to use an Xlookup to return the max date from column C (sheet2) where there is a matching value in column A (sheet1) against column B (sheet2). This is the formula for my two failed attempts below. =IFERROR(XLOOKUP(MAX(A1),Sheet2!B:B,Sheet2!C:C,""),"") Answer returned =...

Hi, I'm looking for a way to find the last (max) date for excel model in power query. Have have many sales and want to use power query to figure out the max of a list. I dont want to do the work in DAX as I think it would be slower. Thanks

Guys I have the following problem. I need to identify if the date of the record is the earliest date of the group. The idea is NOT return an aggregation table, the idea is return all the records but in a custom column I want to identify if the date of the record is the earliest of the group. If...

Hello to all. I am trying to develop an in-cell formula with Index Match. The Match will have multiple criteria, with one of them being a MAX. I cannot seem to get it correct, and I believe it is the MAX as a criteria of the Match which I am not doing correctly. Also, this will be against a...

Hello Experts, I am quite novice to VBA and still learning. So, any help from you would be highly appreciated. I have an excel sheet (Sheet 4) with Machine codes (Column A) and Service Dates (Column B). Same machine code can be repeated in column A, but always with a unique service date. In my...

Hello. I have a code to find min and max dates in Range("A") and Range("A2") and a MsgBox displaying min date(in format number) and another MsgBox displaying min date (in format number). This is my code and works fine: Sub minmaxdate() Dim rng As Range Dim ws As Worksheet Dim ch As...

Hello, I'm trying to query a table to return records with the latest contract date. I've tried a bunch of max date codes that I found on the forum but none of them seem to return what I'm looking for. Here's my table: <tbody> Group Level ContractDate Salary A 1 01/04/2001 10000 A 1...

Hello all, I have found how to find the second newest date using the Large function. However it only works when there is only one instance of the date. I have a table with were each date is recorded three times for three different products. When I use =Large(A:A, 2) it returns the max date as...

I am writing a macro to try and sort some payroll information. On the worksheet, column "I" contains the "payroll end dates" for accounting records in the spreadsheet. I have used the following section of code to find the max date column "I" and assign it to a variable: Dim lastEndDate As Long...

Hi, I am trying to do a vlookup of the square footage of a unit based on the most recent date it was updated. I have gotten to where I can get the most recent square footage but I can't figure out how to add the condition in so that I don't have to manually create the unit ranges Here is the...

Hi I have source data into sheet1 like: <tbody> ColumnA ColumnB Audi 01/01/2015 Audi 30/03/2015 Bmw 06/06/2015 Audi 15/07/2015 Bmw 02/02/2015 </tbody> Into sheet2 I have unique list of values from columnA: <tbody> ColumnA ColumnB Audi 15/07/2015 Bmw 06/06/2015 </tbody> How to...

Hello Excel Gurus, I have a problem that has been stifling me for the past 2 weeks. I have a data table that includes a primary product and its components i am trying to forecast for completion within a set of 30 day periods. The components must complete first within enough time to complete the...

I have two worksheets that I am using. Sheet A contains raw data including a key number and a corresponding date. Sheet B just contains a key number. I am trying to find the latest date in a set of values if the key number from Sheet B matches the key # from Sheet A. Example: Sheet A...

Hello all. I want to use =MIN() and =MAX() to find earliest and latest dates in a very large range but cannot get a result, no errors, just empty cells! The date 'values' in the range are linked entries from another work book which I believe may be the cause of the problem. Is that the...

Hi there, I have 2 spreadsheets. 1 is a list of customer names. The other is a list of all the customer invoices from the year. I would like to return the date of the LATEST invoice to the customer name list. Example: Sheet 1 is: <colgroup><col><col><col><col></colgroup><tbody> Customer...

Hi, In column A I have "reported period" and in column C I have "account name". Each month I have new series data contains reported period and account name, and now I want to select MAX date for looking account. Example: <tbody> Reported Period (column A) Account Name (column C) 12/09/2014...

I need to create a report heading that says "Includes YTD sales thru xx/xx/xxxx." I would like to write a VBA which dynamically assigns the maximum sales date that was located within a pivot table field (PivotItem list). Notice that I didn't say that I want to change the filter... I only...

Hi, I have: field = A9 = Region field = F9 = Country field = H9 = City field = J9 = Street field = L9 = here I need function I did pivot pivot table, where I have in column: <tbody> Region Country City Street Date Central Poland Krakow Hoffman 20/03/2013 Central Poland Krakow Hoffman...

Dears, I am trying to get values of colmns Reference (Person Name) & Flag (A,B,C etc) against max date for each of three Types i.e. CREDIT,DEBIT and reversal against A/C (Which may change). Sample data is as under alongwith desired outcome perhaps it may clear my objective. and plz sorry for...