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

Look here for help: http://support.microsoft.com/kb/555375

Regards,
Fred.

"PERANISH" wrote in message
...
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

In B1 put this formula and drag it till u have the data
=LOOKUP(C2,$D2:$G2,$D$1:$G$1)

In C1 put this formula & drag it till u have the data =MAX(D2:G2)
( cell format it to date )





On Jun 1, 8:43*pm, PERANISH
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

Thanks to mr.madhu.
u saved my lot time.

Once again thanks.

-peranish

"muddan madhu" wrote:

In B1 put this formula and drag it till u have the data
=LOOKUP(C2,$D2:$G2,$D$1:$G$1)

In C1 put this formula & drag it till u have the data =MAX(D2:G2)
( cell format it to date )





On Jun 1, 8:43 pm, PERANISH
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

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