Formula to take 2 bits of criteria and deliver the latest date

T

TerryMann

New Member
Joined
Oct 26, 2018
Messages
1
I have spreadsheet with a sheet called "DATA" and a sheet called "TRAINING" in the training sheet I have a personnel ID in C3 and a course ID in D2. I want to search "DATA" for a personnel ID that has done a course in D2 and enter the date on the next due date (some people have done the course more than once so I need it to give me the most current date.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
You must log in or register to reply here.

Similar threads

M
  • Question Question
A search formula (like index match) that can pull the most recent date when multiple matches may occur based on the criteria figure.
Replies
2
Views
152
MARZIOTULLIO
M
A
  • Question Question
Excel - looking up data with multiple criteria from table/array, date must be same or nearest before the target cell
Replies
8
Views
625
Peter_SSs
Peter_SSs
A
  • Solved
Copy Entire Workbook, save as sheet name with current date, hide all sheets except one, & attach to email
Replies
2
Views
640
Amo840812
A
D
  • Question Question
Combing rows to retain latest only the latest data in each column
2
Replies
10
Views
1K
DarkV
D
A
  • Question Question
Macro to move certain columns to new sheet based on status (ie; "done")
2
Replies
10
Views
754
AnnyCav
A

Forum statistics

Threads
1,224,815
Messages
6,181,135
Members
453,021
Latest member
Justyna P

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