Recent content by Data Cruncher

Hello, I can't see how to post an .xls file (the format is not in the list of allowed extensions) and I don't know how to zip the file. I can unzip files, but I can't see how to do the reverse. If I were to paste it into a Word file table, will that do? Data Cruncher

Thanks for the interest. I'll have a shot at attaching it for you. Haven't done that previously, so if I goof, let me know and I'll have another go. Cheers, Data Cruncher.

Hello, I have a two similar lottery result sheets with columns as follows:- Sheet 1 A1,B1,C1,D1,E1,F1,G1,H1,J1 Draw,DrawDate, #1,#2,#3,#4,#5,#6,Supp1,Supp2 Below these I have data at present down to row 1428 To the right of the data I have a split table with the following Headings in Cells...

Many, many thanks. This works perfectly. It's just what I needed. You're a champ. Data Cruncher

Thanks for trying Keith. Fingers crossed, someone can dream up a Macro for me or tell me how to lay the data out to make it easier. Data Cruncher.

Hello Terry, I would probably try this:- 1) Sort your column data into numerical order (if that is how you want it to end up) 2) Copy the data and paste into Word (insert a few spare paragraph marks first and paste at the 2nd of these) and make sure the columns stay selected 3) Go to...

Hello, I have a large series of individual numbers in 5 columns, running down to 574 rows, including the headers. The data, which comprises numbers from 1 to 45 inclusive in each row, has been entered without being put into numerical order (aaaarrrgh!!!!), so filtering for specific...