Sort/Filter

Robm1955

DullGreyGuy said:

The easiest solution is rather than having 4 columns for balls with each cell containing a value instead to have columns for each of the balls and then just put an X in the columns for the 4 balls they want. You then simply can filter column 7 for X (or non-blanks) 

There are plenty of other options but it really does depend on how you want to operate the thing 

I think that would complicate things for the people taking part. They need to look for their name to see if their number as won. The easiest way is in the format I've done.

DullGreyGuy

Robm1955 said:

DullGreyGuy said:

The easiest solution is rather than having 4 columns for balls with each cell containing a value instead to have columns for each of the balls and then just put an X in the columns for the 4 balls they want. You then simply can filter column 7 for X (or non-blanks) 

There are plenty of other options but it really does depend on how you want to operate the thing 

I think that would complicate things for the people taking part. They need to look for their name to see if their number as won. The easiest way is in the format I've done.

As I said, there are plenty of options and it comes down to the wider consideration of how its to be used... was just one solution for the single issue presented