Most recent date based on match

**Christopherdj** · 09-30-2022, 10:13 PM

Hi
I have a massive data sheet where I need to find the most recent date when matched with two columns of data.
In the file provided, the "RAW_Data" sheet has a sample of all the data.
In the second sheet "Results", I have provided the outcome based on matching the two columns A and C, with the most recent date provided in column E.

The raw data has multiple matches and may include duplicated dates, as long as the most recent date is provided that is all I need.
thanks for any assistance you can provide, my original data sheet has over 100,000 entries so this would save me loads of time.

thanks
Chris

**wk9128** · 09-30-2022, 10:19 PM

Worksheet or Tab name : Results

Cell E2 formula , Drag down

Formula:

=INDEX(RAW_Data!G:G,MATCH(A2&C2,RAW_Data!A:A&RAW_Data!C:C,))

**Christopherdj** · 09-30-2022, 11:01 PM

Thank you, works when using Ctrl+Shift+Enter
Exactly what I needed.

**HansDouwe** · 09-30-2022, 10:29 PM

An option:

Please create on sheet RAW_DATA in column H a helper column with =A2&C2 and copy down and try on sheet results in cell F2 and copy down:

Formula:

=INDEX(RAW_Data!G2:G999,MATCH(A2&C2,RAW_Data!H2:H999,0))

**Christopherdj** · 09-30-2022, 11:03 PM

Thanks HansDouwe,
similar response but wk9128 has given me the greater outcome given the volume of data in my real file.

**wk9128** · 09-30-2022, 11:09 PM

@Christopherdj You're Welcome. Glad to help . Thank You for the feedback and rep.

**HansDouwe** · 09-30-2022, 11:18 PM

@Christopherdj You're Welcome. Thank You for the feedback.

**josephteh** · 10-01-2022, 12:19 AM

You mentioned most recent date... try this:=AGGREGATE(14,6,RAW_Data!G:G/(VALUE(RAW_Data!A:A)=VALUE(A2))*(RAW_Data!C:C=C2),1)

Most recent date based on match

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Most recent date based on match

Re: Most recent date based on match

Re: Most recent date based on match

Re: Most recent date based on match

Re: Most recent date based on match

Re: Most recent date based on match

Re: Most recent date based on match

Re: Most recent date based on match

Thread Information

Users Browsing this Thread

Similar Threads

Most Recent Values by Date with Index and Match

Index Match Formula that Returns Most Recent Date

[SOLVED] INDEX MATCH Function with most recent date

MATCH and INDEX to find most recent date

MATCH and INDEX to find most recent date and other conditions

[SOLVED] Index(Match()) to find most recent transaction for the same date

Vlookup using Indirect and possibly Match, return most recent date

Bookmarks

Bookmarks

Posting Permissions