latest date from a group of records

D

djbe17

New Member
Joined
Jun 18, 2007
Messages
49
Office Version
  1. 365
Platform
  1. Windows
Hi all,
I have a long list of several thousand assets, and each will have a condition survey recorded periodically.
What i'm trying to figure out is a elegant way to flag up in an adjacent column which is the most recent survey for that specific asset.
I have attached a very simplified sheet, with some dummy data - for this simple example that would look like a flag in Col D , indicating which is the most recent record for "cat", "dog" & "fish"

many thanks in advance.

1626783252392.png
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
How about
Excel Formula: 
=IF(MAXIFS($C$2:$C$100,$A$2:$A$100,A2)=C2,"Latest","")
 
Upvote 0
That's beautifully simple, elegant and efficient - many thanks.
I have overcomplicated / overthought the whole problem and missed the obvious...

Many many thanks.
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Need Latest dates from Column basis on a condition
Replies
2
Views
247
sg2209
S
D
  • Question
Identifying last record in a data set
Replies
7
Views
287
Fluff
Fluff
B
  • Question
Reference UK Post Code Column to Create and print Country from a reference table? IF formula or VLookup?
Replies
5
Views
343
Fluff
Fluff
A
  • Solved
Changing recorded macro to have dynamic selection of cells when trying to format a sheet.
Replies
4
Views
604
Michael M
Michael M
S
  • Question
Pulling values from certain columns based on criteria from multiple sheets on the same workbook and populating in a separate workbook.
Replies
4
Views
409
schurst44
S

Forum statistics

Threads
1,215,453
Messages
6,124,925
Members
449,195
Latest member
Stevenciu

Share this page

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