Frank
Member
Khanaran,
I am having difficulty understanding your problem. The Original match spreadsheet I uploaded used the table W2:AD16 to identify matches in column I, specifically I6:I65 which matched with any cells in the table M2:U16.
This identifying table W2:AD16 DOES update when you udate your results. It still looks at I6:I65 even though the contents have scrolled down one. This means that the yellow highlights in table M2:U16 (which refer to the other table) also updates and cells which were yellow before now reset to white background if there is now no match.
In the version you uploaded there appears to be yellow highlighting in certain cells in the table W2:AD16. This colouring has nothing to do with me. There is no conditional formatting in the table. You must have highlighted those. Why ? The table was just a construct to aid the other table colour scheme!
When you say "In the match sheet, when a number that was previously shaded is automatically deleted from the updating , it leaves they yellow shade can this be set so that it shades only if the cell contains value". I cannot understand what you are saying here. You need to specify a cell you think isnt working properly, in which table.
For the sorting problem, you need to know that there are 2 ways of sorting.
1. Each column independently of everything adjacent to it, as though the others were not there.
2. Sort all 3 columns as a group, which you select, then sort first by column 3 (your label), then by column 2, then by column 1
The first sort destroys the relationship between the three digits, whilst the second preserves each row of 3 digits but creates a descending order of ( a group of 3 digits).
I have written macros ( to be honest, recorded them ) for BOTH types of sort to show the difference.
For the first type of sort, Excel would try and link all adjacent columns by expanding the selected range, which you have to reject. (new) Macro 7
For the second type of sort I think Excel is quite user friendly, since it allows you to add levels of sort (in this case 3 levels) in which you set which column you are sorting by and whether ascending or descending. Macro 8
For both types of sort Ive left your numbering 1 to 0 out of the sort, so it remains the same.
You choose which you actually meant to use.
http://www.mediafire.com/file/ub4zcevpr2eqtpd/match%283%29.xlsm
Well you dont say how many results to scan ! I suppose just the latest would make sense. You dont say what you want to do when youve anticipated the double digit draw ( throw a party ?) or what double digits !
if you put formula :-
=IF(COUNTIF(D6:F6,"=3")+COUNTIF(D6:F6,"=6")+COUNTIF(D6:F6,"=9"),"Yes","") In cell G1 on the match sheet it flags up if either 3,6 or 9 are in the latest result. However I think you'll find a lot of your results will find such matches, so how useful is it ?
Please let me know about the highlighting problem.
I am having difficulty understanding your problem. The Original match spreadsheet I uploaded used the table W2:AD16 to identify matches in column I, specifically I6:I65 which matched with any cells in the table M2:U16.
This identifying table W2:AD16 DOES update when you udate your results. It still looks at I6:I65 even though the contents have scrolled down one. This means that the yellow highlights in table M2:U16 (which refer to the other table) also updates and cells which were yellow before now reset to white background if there is now no match.
In the version you uploaded there appears to be yellow highlighting in certain cells in the table W2:AD16. This colouring has nothing to do with me. There is no conditional formatting in the table. You must have highlighted those. Why ? The table was just a construct to aid the other table colour scheme!
When you say "In the match sheet, when a number that was previously shaded is automatically deleted from the updating , it leaves they yellow shade can this be set so that it shades only if the cell contains value". I cannot understand what you are saying here. You need to specify a cell you think isnt working properly, in which table.
For the sorting problem, you need to know that there are 2 ways of sorting.
1. Each column independently of everything adjacent to it, as though the others were not there.
2. Sort all 3 columns as a group, which you select, then sort first by column 3 (your label), then by column 2, then by column 1
The first sort destroys the relationship between the three digits, whilst the second preserves each row of 3 digits but creates a descending order of ( a group of 3 digits).
I have written macros ( to be honest, recorded them ) for BOTH types of sort to show the difference.
For the first type of sort, Excel would try and link all adjacent columns by expanding the selected range, which you have to reject. (new) Macro 7
For the second type of sort I think Excel is quite user friendly, since it allows you to add levels of sort (in this case 3 levels) in which you set which column you are sorting by and whether ascending or descending. Macro 8
For both types of sort Ive left your numbering 1 to 0 out of the sort, so it remains the same.
You choose which you actually meant to use.
http://www.mediafire.com/file/ub4zcevpr2eqtpd/match%283%29.xlsm
Hi Frank
I further question if I may trouble you further..
Will it be possible to scan results and if either a 3,6 or 9 ball has been drawn, anticipate the a double digit draw inthe next or subsequent draw
Once again thank you for your help and guidance
Raj
Well you dont say how many results to scan ! I suppose just the latest would make sense. You dont say what you want to do when youve anticipated the double digit draw ( throw a party ?) or what double digits !
if you put formula :-
=IF(COUNTIF(D6:F6,"=3")+COUNTIF(D6:F6,"=6")+COUNTIF(D6:F6,"=9"),"Yes","") In cell G1 on the match sheet it flags up if either 3,6 or 9 are in the latest result. However I think you'll find a lot of your results will find such matches, so how useful is it ?
Please let me know about the highlighting problem.