Number of Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 80,000 records I wanted to put into Excel. I then found out that Excel can only handle 65,536. Is it possible for me to put this data in two columns, but I need to sort the data from smallest to largest across both columns combined?

Thanks
 
Sorry no. Can you put this data into something else ? A database of some sort perhaps ?

--
HTH. Best wishes Harald
Followup to newsgroup only please.

Joshua said:
I have 80,000 records I wanted to put into Excel. I then found out that Excel can only
Click to expand...
handle 65,536. Is it possible for me to put this data in two columns, but I need to sort
the data from smallest to largest across both columns combined?
 
How about putting them into separate sheets, use a UNION then sort e.g.

SELECT Col1, Col2
FROM [Sheet1$]
UNION
SELECT Col1, Col2
FROM [Sheet2$]
ORDER BY 1,2

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot sort data 6
Cannot sort data 1
First Value in Sorted Column is Not Sorted Properly 3
Sorting Columns by number of characters 1
smallest to largest 9
ranking numbers in a column 7
Find values across a row and return a text value from the same column 2
Converting 1

Back
Top