Having some trouble with this one!
I have a spreadsheet with numerical values in columns I, L, O, R and U. Additionally, these columns may have no data in them as well. The data starts at the fourth cell and each column may be a different length.
I'm trying to combine these columns to column W.
Then I need to sort the data descending, identify and then count duplicates (if any).
The attached spreadsheet has the code I've been trying to tweak to work. I haven't been able to figure out how to correctly combine all the variable sized ranges.