ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,540
Office Version
  1. 365
Platform
  1. Windows
Good evening all,

I am trying to identify what the last communications are from a large range/list of data

All I need is "Latest Communication" if the date from C12:F12:10003 and job from F12:F10003 is the last entered or if the only one entered


Each job may have been communicated more than once, yet some might be only once


I am looking for a visual aid to show what the latest communication is

"" if previous

Many thanks
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Try

Must be committed with CONTROL+SHIFT+ENTER
Code:
=IF(MAX(IF($F$12:$F$10003=F12,$C$12:$C$10003))=C12,"last date marker","")
 
Upvote 0
That's great thanks Scott,

Could this be extended to 3 columns of data instead of 2

Thanks
 
Upvote 0
Not sure what you mean. Can you post a sample of your data.
 
Upvote 0
Hi Scott,

Basically each job number may have more than one topic, so I need the "Latest Date" for each topic as well as job number reference

This would be from column G

So I would need each job reference and topic to have a "Last date"

Many thanks
 
Upvote 0
Try
Must be committed with CONTROL+SHIFT+ENTER
Code:
=IF(AND(MAX(($C$12:$C$10003*($F$12:$F$10003=F12)*($G$12:$G$10003=G12)))=C12,C12<>""),"Latest Communication","")
 
Upvote 0
Make sure you use CONTROL+SHIFT+ENTER. Does your formula have the {} around it in the formula bar?
 
Upvote 0
Hi Scott,

I have applied CTR+SHFT+ENT and I have the {} around the formula

Its very strange

I have 2007 excel if that makes a difference

Thanks
 
Upvote 0
Just figured it out, date format in column C

All good now

Many thanks
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

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