Dear Excel folks,
I am trying to write a vba code that can identify the max date from column using based on an adjacent value as reference
Have tried using of array formulas but it slows down the processing time quite considerably
Below is a sample ranging from A1 to C8
_____ A____ |____B____ I__C__|
1 | Jane Doye | 01/01/2005 | No
2 | Tom Smith | 01/01/2011 | Yes
3 | Jane Doye | 01/01/2004 | No
4 | Jane Doye | 01/01/2008 | No
5 | Jane Doye | 01/01/2006 | No
6 | Jane Doye | 01/01/2010 | Yes
7 | Jane Doye | 01/01/2009 | No
8 | Tom Smith | 01/01/2008 | No
Basing on the above example, once the macros is triggered, column C will display string "Yes" if the row contains the latest date - based on the individual in column A
I hope the sample is sufficiently concise and clear!
Looking forward to any directions on this.
Thanks
Jensen
Bookmarks