I would start with the manual. You can filter for unique records - which you can extrapolate into finding duplicates, sorting and adding calcuation columns to determine gaps and sequences is a common practice. There are no basic formula for these operations of which I am aware.
_________________________
The opinions expressed here should not be construed to be those of my employer: PPDocs.com