| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
UNIQUE VALUE
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filtering unique in multiple columns | Excel Worksheet Functions | |||
| code not unique find latest date | Excel Discussion (Misc queries) | |||
| Unique numbers if between dates | Excel Worksheet Functions | |||
| count unique with conditions | Excel Worksheet Functions | |||
| Count Unique Values | Excel Worksheet Functions | |||
Threaded Mode
