ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,465
Office Version
  1. 2007
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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,628
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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","")
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,465
Office Version
  1. 2007
Platform
  1. Windows
That's great thanks Scott,

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

Thanks
 

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,628
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Not sure what you mean. Can you post a sample of your data.
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,465
Office Version
  1. 2007
Platform
  1. Windows

ADVERTISEMENT

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

Well-known Member
Joined
Dec 14, 2016
Messages
2,628
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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","")
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,465
Office Version
  1. 2007
Platform
  1. Windows

ADVERTISEMENT

Hi Scott,

#VALUE im afraid,

Does this work on 2007
 

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,628
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Make sure you use CONTROL+SHIFT+ENTER. Does your formula have the {} around it in the formula bar?
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,465
Office Version
  1. 2007
Platform
  1. Windows
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

Well-known Member
Joined
Oct 2, 2006
Messages
2,465
Office Version
  1. 2007
Platform
  1. Windows
Just figured it out, date format in column C

All good now

Many thanks
 

Forum statistics

Threads
1,144,625
Messages
5,725,365
Members
422,621
Latest member
dfrare

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
Top