Search results

  1. D

    Returning a Cell's contents where a range meets specific criteria

    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...
  2. D

    Sorting by rows - How can I speed up the process?

    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...
Top Bottom