I have two columns of text and I need to calculate the median for a third column of data for every combination of text from the two first columns. For example I need to work out the median for all values from the following combination:
Newbury 2009-2010 Q1
But the combinations aren't necessarily grouped together and I don't want to have to sort the data if possible.
Bookmarks