Filter or Formula for Last Work

[Vishaal]

Hi, we have posted this question on the following url but in this there are some change in requirement, we have around 100-200 entry and taking the result in new sheet
only for example we have used the same sheet.

Filter or Formula for Processing Work

HI, we have the following sheet where we want to check the steps where are work is pending, kindly provide any excel formula we have the excel 2007, 2010 sheet ABCDEFGHIJKLMNOPQRS1WorkStep 1Step 2Step 3Step 4Step 5Step...

www.mrexcel.com

we have the following sheet where we want to get the some result
Data Sheet

New Microsoft Excel Worksheet - Copy.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Work	Step 1			Step 2			Step 3			Step 4			Step 5			Step 6
2		Date	Status	Late	Date	Status	Late	Date	Status	Late	Date	Status	Late	Date	Status	Late	Date	Status	Late
3	John	21/08/2012	Done		23/08/2012	Done		26/08/2012	Done		28/08/2012	Done		30/08/2012
4	Dan	24/08/2012	Done		26/08/2012	Done		27/08/2012	Done		28/08/2012
5	Ronshi	24/08/2012	Done		26/08/2012	Done		27/08/2012
6	Pome	21/09/2012	Done		23/09/2012	Done		26/09/2012	Done		28/09/2012	Done		30/09/2012	Done		1/10/2012
Sheet6

Result Sheet

New Microsoft Excel Worksheet - Copy.xlsx
	A	B
17	Status of Step
18	Dan	Step 4
19	John	Step 5
20	Pome	Step 6
21	Ronshi	Step 3
Sheet6

 

[Peter_SSs]

Like this?

23 08 05.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Work	Step 1			Step 2			Step 3			Step 4			Step 5			Step 6
2		Date	Status	Late	Date	Status	Late	Date	Status	Late	Date	Status	Late	Date	Status	Late	Date	Status	Late
3	John	21/08/2012	Done		23/08/2012	Done		26/08/2012	Done		28/08/2012	Done		30/08/2012
4	Dan	24/08/2012	Done		26/08/2012	Done		27/08/2012	Done		28/08/2012
5	Ronshi	24/08/2012	Done		26/08/2012	Done		27/08/2012
6	Pome	21/09/2012	Done		23/09/2012	Done		26/09/2012	Done		28/09/2012	Done		30/09/2012	Done		1/10/2012
7
8
16
17	Status of Step
18	Dan	Step 4
19	John	Step 5
20	Pome	Step 6
21	Ronshi	Step 3
Step

Cell Formulas
Range	Formula
B18:B21	B18	=LOOKUP(9^9,INDEX(B$3:S$6,MATCH(A18,A$3:A$6,0),0),B$1:S$1)

 

[Vishaal]

Thansk Peter_SSs, its working

 

[Peter_SSs]

Glad to help.