returning multiple values from a series

[dan cameron]

If anyone knows an easy way to do this or has an example of some code, I'd be stoked if you could share it!

I'm basically trying to extract a date corresponding to a maximum value in a series - I know I can use the VLOOKUP worksheet function for this. However, my quandry is that I need to do this for multiple values in the same series (for example: maximum occurs on 3 occasions). Is there some way that I can do it easily, or does it need code (I do code, just not fast, well or with much flair).

Cammo

[duane]

could you sort the data in descending order of the variable in question, and then filter to only the maximum value, copy and paste somewhere?

[dan cameron]

Thanks Duane. I've done something like that already but I still have the problem of getting excel to return the corresponding date for each time a maximum is reached..

Keep the ideas comin though