reuest formula for auto update status & status date
Thanks for your formula. it will reduce my lot time. i got 2 different .
Once again Thanks
-Peranish
"GoBow777" wrote:
PERANISH;674258 Wrote:
A B C D E F
G
ITEM STATUS STATUS DATE SETTING WELDING TESTING
OMPLETE
AB-01 COMPLETE 6/25/08 5/10/08 5/11/08 6/20/08
6/25/08
AB-02 SETTING 5/25/08 5/25/08
AB-03 TESTING 5/10/08 4/20/08 4/25/08 5/10/08
AB-04 WELDING 3/02/08 2/26/08 3/02/08
I WANT FORMULA, WHERE LATEST DATE ENETERD IN (COL-D €€œ G),
THAT HEADING WILL
APPEAR IN STATUS(COL-B) & STATUS DATE WILL BE APPEAR IN COL-C. PLEASE
REFER
THE ABOVE EXAMPLE.INPUT AS DATE & RSULT WILL BE IN COL-B & COL-C
REQUEST YOU TO HELP ON THIS.
-PERANISH
PERANISH:
Assuming the headers are in row 1, use this function to populate column
C.
=IF(MAX(D2:G2)=0,"",MAX(D2:G2))
Use this formula to populate column B.
=IF(C2="","",INDEX(D$1:G$1,MATCH(C2,D2:G2,0)))
Matt
--
GoBow777
|