[Solved] Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]

by


I solved this by recording a macro that copys and pastes the data values into another section then I sorted it largest to smallest.

I then created a column with the equation to subtract one from the other.

solved Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]