Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
customer | event | date |
---|---|---|
1 | sign | 1/2/12 |
1 | apply | 1/3/12 |
1 | accept | 1/5/12 |
1 | renew | 1/7/12 |
2 | sign | 2/7/12 |
2 | apply | 2/3/12 |
2 | accept | 3/12/12 |
2 | deny | 1/4/12 |
3 | apply | 2/1/12 |
3 | renew | 3/12/12 |
customer | event | date |
---|---|---|
1 | renew | 1/7/12 |
2 | accept | 3/12/12 |
3 | renew | 3/12/12 |
however, if i select an event (i.e. sign), i want to see the 'signs' so i don't want to eliminate the other values, just display the most recent if no events are selected.
thanks!
HI
Try like this
=FirstSortedValue(Customer,-date)
Hope it helps