New
#1
Excel spreadsheet of Lotto results - formula question
I'm trying to query a spreadsheet of 100 Lotto draws.
I want to re-order all rows of 6 numbers from drawn order to low-high numeric order.
Here are a few typical ball sequences in the order the balls emerged:
a) 40-10-25-22-4-16
b) 34-17-7-39-31-30
c) 24-3-40-25-7-11
Instead, I'd like the sequences to look like this:
a) 4-10-16-22-25-40
b) 7-17-30-31-34-39
c) 3-7-11-24-25-40
Is this possible?
Thanks.