I need a formula that will display the following ranking list in the attached file, and which will eliminate companies with Non-applicable information.
The main issues I am having are with the Fee, Company, and Revenue categories because I do not want "N/A" showing up under revenue or the companies associated with it.
Is there a way to eliminate the consideration for Companies E and F in a formula, so that those companies are neglected and excel goes on to input Companies I and C instead (in a ranked format as well)?
Bookmarks