Find the Largest Difference

Hi There

I hope someone will be able to help me..........

I have a pivot table that shows values grouped as ranges in the row, Gender as the columns and an average % value in the data.

In a cell outside of the pivot I would like to be able to produce the name of the range that has the largest difference between male and female.

I hope this makes sense and that someone can help. I have thought about getting the min and Max values but this doesn't mean finding the biggest difference so at the moment I am pretty lost for ideas.

I can post an example if this makes not sence at all

Thanks in advance.

Jim