Hi

I am really not very good with excel but am hoping that is a formula that can help me. I have a two rows of data - the top one is the dates in a month (the actual month is in column a) and the row underneath the dates contains figures (website visits). I need to extract the highest number of website visits each month into another cell but have it highlight the date of the month it is (if that makes sense).

Eg. If the highest number of visits is 95 I need to pull through that as well as the date of the month it was into a summary sheet.

Hope this makes sense - sorry for waffling but I hope someone can help

Cheers