Greetings,
I have been wracking my brain trying to come up with a solution to an Index Problem. I am looking to have a formula look at an entire sheet, return the largest Number (from a column) but only if a cell in a column meets a condition.
In my example I have Column A with Directors and...