Selecting the most recent date from group of cells

R

richmcgill

Board Regular
Joined
Feb 4, 2019
Messages
71
Office Version
  1. 2016
Platform
  1. Windows
I am looking to find the most recent date from each row. The trouble I have been having is not all the information on the row is a date.

Looking at row 2 I need to look at cells A2, C2, E2, G2 AND I2 and put the most recent date in K2/Results.

Is this something someone could help me with?

1686160200164.png
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
The MAX function should work, i.e.
Excel Formula: 
=MAX(A2:J2)
 
Upvote 1
Solution
You are welcome.
Glad I was able to help!
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
264
Insurance Dave
I
T
  • Solved
Most Recent Result
Replies
7
Views
198
Fluff
Fluff
M
  • Solved
VBA to find most recent Invoice Date for each Customer
2
Replies
10
Views
621
kevin9999
K
M
  • Solved
Counting given amount of consecutives
2 3 4
Replies
37
Views
691
Marvo
M
S
  • Question
Find exact name across multiple tabs & combine with data from the most recent tab?
Replies
0
Views
73
Sunshine8790
S

Forum statistics

Threads
1,215,148
Messages
6,123,307
Members
449,095
Latest member
Chestertim

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