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