Streamlining VBA code to help faster processing

Hi guys,

I am using the following VBA code in one of my excel workbooks:

Please Login or Register  to view this content.

This code calculates the median of entries in column C based on values in columns A and B and puts the median in column D.
I want to modify this code to implement an additional functionality. Since there is a repetition of data in my worksheet, I want the code to compare the current cell with all the previous cells and skip the median calculation if it has already been done. Any ideas on how to do this?

Thanks.

Assuming (from before) that the data is unsorted the quickest approach is to concatenate the two columns of interest enabling you to conduct a quick COUNTIF test against the concatenation column... else you will need to use an approach along the lines of:

=IF(ISNUMBER(LOOKUP(2,1/((rangeA=valueA)*(rangeB=valueB)))),MEDIAN(IF(...)),"")

This will still be quicker than conducting all of the arrays you're presently conducting but not as fast as it could be... you could if preferred even ensure you only insert formulae into the relevant cells... ie:

Please Login or Register  to view this content.