There is probably a very simple solution to this problem, but I can't figure
out how to address it.

I'm ranking a list of stock symbols, best to worst, by 2 different criteria
through a separate program. The list consists of about 7000 symbols.

I want to dump the list (based on external software rankings) into 2 Excel
columns, based on the rank from each of the 2 criteria (this ranking will be
performed by external software). Then, I wish to instruct Excel to rank the
symbols based on the combined scores of the two column, from best to worst,
in a third column (or however many columns it takes to accomplish this).

Additionally, I'm hoping that Excel can be instructed to list the stocks
from best to worst, based on the combined scores.

Can somebody help me with this? I'm sure this is basic and I'm happy to pay
for any assistance.