D
duketter
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!
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!