Is there a way I can rank data in multiple ranges? Right now I have 4 data
sets that are a few columns apart from each other... I want to be able to
rank each sales amount in each column out of the total sales $ from ALL
Columns.

Currently there is data in Columns B8:B1500, H8:H1500 L8:L1500 and P8:P1500
and I want to be able to rank say B8 out of ALL the data in all columns...

Anyone able to help?