Hi,
I could use some help with this one.
I have a horizontal list of numbers that represent values for weeks 1 to 52. I know how to figure out the highest week's value (using the max formula) but don't know how to figure out what week it happened in. ie: I know in week 23 I had my highest number, but how do I write a formula that counts to the max value and tells me it's number 23????
If anyone can help me figure this out, I would greatly appreciate it.
Thanks
Bookmarks