View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Help with a calculation (no VBA)

D2: =MAX(MONTH(E2:Z2))

C2: =MIN(IF(E2:Z2<"",MONTH(E2:Z2)))

The formula in C2 is an array formula, it should be committed with
Ctrl-Shift-Enter, not just Enter.


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"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!