Lookup Formular on Table
That should have read
Enter in G2
=INDEX($B$1:$F$1,MATCH(LOOKUP(99^99,B2:F2),B2:F2))
--
Regards
Roger Govier
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi
In G" enter
=INDEX($B$1:$F$1,MATCH(LOOKUP(99^99,B2:F2),B2:F2))
and copy down
--
Regards
Roger Govier
wrote in message
...
HI all.
Is there a formular that I can put in the last column " Last came"
that will look along the row for the last data entry that a Boy
attended and bring back the date on the top label?
So For example Harry's last attendance was in Jan-01, where as William
last came in Apr-01.
I have done this via a Macro but was hoping to use a formular instead.
You help is appreciated
Denz
Jan-01 Feb-01 Mar-01 Apr-01 May-01 Last Came
Tom 1 1 1 1 May-01
Harry 1 Jan-01
William 1 1 1 Apr-01
James 1 1 May-01
Peter 1 1 1 Mar-01
|