UNIQUE VALUE

E

elephant

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
 
B

Bob Phillips

Use

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
R

Ragdyer

If the visits are not contiguous, try these:

First:
=IF(COUNTIF($A$2:A2,A2)=1,1,0)

Last:
=IF(COUNTIF(A2:$A$11,A2)>1,0,1)
 
E

elephant

Cheers Ragdyer! That's now working. I will however, try to understand
the logic better. Thanx
 
Top