Use

=IF($A3=$A2,0,1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"elephant" wrote in message
oups.com...
Hi people, I have a formula that picks the last value in a row. This is
a case where clients are identified by a the same number every time
they visit a clinic. My formula only picks the last visit. How do i
pick the first visit? Thanx in advance.
A B
3 1 =IF($A3-$A4=0,0,1)
8 1
17 0
17 0
17 0
17 0
17 1
18 0
18 1
19 0