Latest Date

[ExcelRoy]

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

 

[Scott T]

Try

Must be committed with CONTROL+SHIFT+ENTER

=IF(MAX(IF($F$12:$F$10003=F12,$C$12:$C$10003))=C12,"last date marker","")

 

[ExcelRoy]

That's great thanks Scott,

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

Thanks

 

[Scott T]

Not sure what you mean. Can you post a sample of your data.

 

[ExcelRoy]

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

 

[Scott T]

Try
Must be committed with CONTROL+SHIFT+ENTER

=IF(AND(MAX(($C$12:$C$10003*($F$12:$F$10003=F12)*($G$12:$G$10003=G12)))=C12,C12<>""),"Latest Communication","")

 

[ExcelRoy]

Hi Scott,

#VALUE im afraid,

Does this work on 2007

 

[Scott T]

Make sure you use CONTROL+SHIFT+ENTER. Does your formula have the {} around it in the formula bar?

 

[ExcelRoy]

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

 

[ExcelRoy]

Just figured it out, date format in column C

All good now

Many thanks