Ok, so you will you see 3 tabs for this example. The first tab shows everything I need to see, the 2nd tab is a list of all of the information, the third tab is just a list of all of the opportunities.
You will see on Tab 1, column C, this is the formula I thought would work, clearly it is not. What is needed is that in Column C, I need the lowest date from Tab 2, that meets the same criteria. For Example.
If on the 2nd Tab, Hollins University with the opportunity name, "2010 Six Campus Buildings", everything should show nothing, expect for under "100%" the date should read 3/5/2010.
Any help would be great!
Bookmarks