Number of Rows

J

Joshua

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
 
H

Harald Staff

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?
 
O

onedaywhen

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

--
 
Top