extracting the highest number from data

[hazelbl]

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

[NBVC]

Say you dates are in Row A1:AB1 and your numbers are in row A2:AB2,

Then =Max(A2:AB2) would get max number

For highlighting, select range with dates (e.g. A1:AB1) and go to Format|Conditional Format

Select Formula Is from 1st Dropdown and enter formula: =A2=Max($A$2:$AB$2)

click Format and choose you highlight from the Pattern tab.

Click Ok and clikc ok again to finish.

[hazelbl]

thank you for your help - I have got this to work but I am looking actually not to highlight the number as i have a massive table full of numbers some of which are already highlighted and bold etc. I was hoping to be able to pull this information into a different cell - e.g. in cell AO2 would be the max value and in AP2 would be the date it occurred.

Hope you can help!

[NBVC]

thank you for your help - I have got this to work but I am looking actually not to highlight the number as i have a massive table full of numbers some of which are already highlighted and bold etc. I was hoping to be able to pull this information into a different cell - e.g. in cell AO2 would be the max value and in AP2 would be the date it occurred.

Hope you can help!

So again, if your dates are in A1:AB1 and numbers are in A2:AB2

Cell AO2: =Max(A2:AB2)
Cell AP2: =Index(A1:AB1,Match(Max(A2:AB2),A2:AB2,0)) or Index(A1:AB1,Match(A02,A2:AB2,0))

[hazelbl]

that is amazing - thank you!