One thing is to use the Excel ROW numbers to companr against your columns, or
make some real sequential columns as you would like them to be and compare
against your existing columns..........

Vaya con Dios,
Chuck, CABGx3



"duketter" wrote:

Excel 2003 - Is there anyway to sort multiple columns to look for gaps. What
I have is 8 different spreadsheets and he spreadsheet contains about 64,000
lines (almost the max Excel allows). There is a column in each spreadsheet
that is a unique identifier and should not contain a gap. However, the
numbers are in no particular order. So for instance, spreadsheet 1 contains
the numbers 1,2,4. Spreadsheet number 3 might contain the number 3 so there
is no gap.

Due to the large nature of the spreadsheet, I cannot put all these numbers
into on column in one spreadsheet and just sort for the answer. Is there a
way to put a bunch of different columns into one spreadsheet and then do a
sort of somekind to look for any gaps between the numbers?

Thanks!