Hey,
I have 2 columns populated with data
Column A = Date
Column B = Value
I have my sheet already finding and highlighting the weekend days, but I need to find the Max value that is seen only on a weekend.
I have to do this for every month so the weekend days are at different spots of each month.
Also when it finds the maximum value I need it to display the date that it occurred on in a cell next to it.
Any help would be great, I've been looking through forums for the past 2 days with no help.
Thanks,
Bookmarks