Have a question ---
I have a database 9 columns 236 rows.
------ would like to do an iterative data comparison
i.e. compare all 9 cells in row 1 and if they are <= cells in row 2, then return a 1 (true) or 0 (false), then compare row1 to row3, row1 to row4 etc until we have done comparison of row1 to row236.
Then do the same thing for row2 --- cf. row2 to row3, row2 to row 4 ....
Row2 to row236. etc etc.
Any ideas on how to do this efficiently.
Thanks in advance
I have a database 9 columns 236 rows.
------ would like to do an iterative data comparison
i.e. compare all 9 cells in row 1 and if they are <= cells in row 2, then return a 1 (true) or 0 (false), then compare row1 to row3, row1 to row4 etc until we have done comparison of row1 to row236.
Then do the same thing for row2 --- cf. row2 to row3, row2 to row 4 ....
Row2 to row236. etc etc.
Any ideas on how to do this efficiently.
Thanks in advance