Skip to content
BOL Conferences
Thread Options
#317132 - 02/16/05 12:02 AM Excel Tools
Fede Offline
New Poster
Joined: Feb 2005
Posts: 2
Argentina
Hi, anyone knows where I can find excel formulas to find gaps, duplicates, secuences, etc ??. Help !!. Thanx !.
_________________________
It Auditor

Return to Top
Audit
#317133 - 02/16/05 01:38 AM Re: Excel Tools
rlcarey Online
10K Club
rlcarey
Joined: Jul 2001
Posts: 83,368
Galveston, TX
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

Return to Top

Moderator:  Andy_Z