How about a Pivot Table?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"VSAT Ryan" wrote in message
...
Picture this:
WBS Listings in column A. Labor Grade Listings in Column B. Column C is
"Min Start". Column D is "Max Finish". Columns E - Z represent
Nov06-Apr08.
Depending on the WBS and Labor Grade, there are values entered in
different
months. There are multiple instances of the Same WBS, and same labor
grade
within the WBS. Ultimately, the Min start per WBS will be put into a
pivot
table for min start.
I'd like a formula that looks at the WBS in Column A, finds the earliest
month where are values entered in, and returns the month in Column C.
Hopefully I explained this well enough! Thanks for your help!