Help with a calculation (no VBA)
 

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!

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!

Help with a calculation (no VBA)
 

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!