cell position and find last <> null cell

[PaulMouadib]

hello all.
I would like some help about a problem i am faceing. (I am using excel 2003) .
First of all ,i have this worksheet :

i have several people (colA) -
who are paying in 3 different methods (pay1-pay2-pay3) -
each person pays several times in a year (pay method can be anything)
I am trying to find a way :
To find the DATE of the last payment on each person ,at each payment method ( for example Alice pay1 is apr09 ) and put the date in cell for example b4 in a other worksheet.
..
Any help or insight would be apreciated .
sorry for a long post .
thank you for your time
Paul.

 

[dave3009]

Something like

Excel Workbook
	A	B	C	D	E	F
1	NAMES	JAN 09	FEB 09	MAR 09	APR 09	LAST
2	NICK			PAY		MAR 09
3	GEORGE	PAY				JAN 09
4	ALICE				PAY	APR 09
5	JOE		PAY			FEB 09
6	BILL	PAY				JAN 09
7	KATE			PAY		MAR 09
8	PETER	PAY				JAN 09
9	ROBERT				PAY	APR 09
Sheet2

Excel 2007

Cell Formulas
Range	Formula
F2	=LOOKUP("zzz", B2:E2, $B$1:$E$1)
F3	=LOOKUP("zzz", B3:E3, $B$1:$E$1)
F4	=LOOKUP("zzz", B4:E4, $B$1:$E$1)
F5	=LOOKUP("zzz", B5:E5, $B$1:$E$1)
F6	=LOOKUP("zzz", B6:E6, $B$1:$E$1)
F7	=LOOKUP("zzz", B7:E7, $B$1:$E$1)
F8	=LOOKUP("zzz", B8:E8, $B$1:$E$1)
F9	=LOOKUP("zzz", B9:E9, $B$1:$E$1)

 

[PaulMouadib]

thank you very much dave3009

works perfect ! ! !