Hello, I have been trying to create some efficiencies in my files using vba and macro's and i am currently in holding pattern. I have a number of columns that all contain different types of data (one column is names, others dates,..etc. However, in column C, i have 3 distinct values (CTR, BTW, and ATY) only. In column E, I have dates with times. I am trying to write a formula/macro that will provide me with the maximum date for (CTR) and the maximum date for (BTW & ATY); the date may change based on the date that the download occurs. I have tried to use the formula max and I have even tried to index the data. However, the answer is always coming back with the max date for the entire row. Plus, to add a complication, the range is variable and depends on the amount of data so its never a fixed range. I really hope someone can help. Thank you in advance for any thoughts on this.