I am looking for code that will input the last date of contact based on the customer number in column F sheet Reminders and the customer number in column D in sheet Data, there can be occasions that there are as many as 5 different contacts so I need the code to pick the last occurance and to input the date into column AK respectively.
Thanks in Advance
Hi Burt,
I put them in AO since AK was occupied - just change the red code to put them wherever you want
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
As an alternative to using VBA, you could use an array formula:
{=MAX(IF(Data!$D$2:$D$1676=Reminders!F2,Data!$F$2:$F$1676))}
in column AK to find the maximum date.
Excel 2016 latest release has a new MAXIF formula, but the above should work with previous versions.
If this has been of help, a click * Add Reputation button would be appreciated. Many thanks
Hi Burt,
Thanks for the rep!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks