Hi,
I am trying to Random sort from column B but only if there is a value in column B. after the random sort from col B, data in the example below rows 9,11,15,16 will be under the last number in col B.
The sheet name is : template and on the sheet the columns in the sort range are B:L and the row range is 7:40.
this is for a sports club and if some is not going to attend I delete the number in col B, so I random sort only those who will be in attendance.
thanks in advance
I am trying to Random sort from column B but only if there is a value in column B. after the random sort from col B, data in the example below rows 9,11,15,16 will be under the last number in col B.
The sheet name is : template and on the sheet the columns in the sort range are B:L and the row range is 7:40.
this is for a sports club and if some is not going to attend I delete the number in col B, so I random sort only those who will be in attendance.
thanks in advance
A | B | C | D | E | F | G | H | I | J | K | L | |
7 | 0.6459567 | 21 | 45 | Alan | Smith | =if(h7+"","",k7+j7) | ||||||
8 | 0.9768443 | 14 | 52 | Greg | Jones | 0 | ||||||
9 | 25 | 41 | Bruce | Brown | 0 | |||||||
10 | 0.0316331 | 19 | 47 | Colin | White | 0 | ||||||
11 | 26 | 40 | Tony | Black | 0 | |||||||
12 | 0.7737984 | 29 | 37 | Roger | Colt | 0 | ||||||
13 | 0.9954291 | 22 | 44 | Joe | Cole | 0 | ||||||
14 | 0.322505 | 23 | 43 | Ron | George | 0 | ||||||
15 | 19 | 47 | Miles | Michaels | 0 | |||||||
16 | 18 | 48 | Len | Werth | 0 | |||||||
17 | 0.1097377 | 11 | 55 | Rick | Johnston | 0 |