{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["RAND,INDEX,RANK.EQ","Sheet7","UNIQUE,RANDARRAY,INDEX,RANK.EQ","RAND,INDEX,RANK.EQ,COUNTIF","INDEX,RANDARRAY,ROWS,SORTBY,SEQ","Sheet6","VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RAND,INDEX,RANK.EQ","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using RAND, INDEX, RANK.EQ Functions"]
[]
[null,"Salesman","Random Value","Sales",null,"Random Cells"]
[null,"Mike",0.75337963049855017,1540,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C5,$C$5:$C$12),1)","v":"Stuart"}]
[null,"Adam",0.69603019685424417,4637,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C6,$C$5:$C$12),1)","v":"Milford"}]
[null,"David",0.12382013278918325,4350,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C7,$C$5:$C$12),1)","v":"Bob"}]
[null,"Hopper",0.92518700647233909,3625,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C8,$C$5:$C$12),1)","v":"Adam"}]
[null,"Stuart",0.85236333105620277,2735,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C9,$C$5:$C$12),1)","v":"Hopper"}]
[null,"Milford",0.24234008916036187,8235]
[null,"Steve",0.89032608592616247,1524]
[null,"Bob",0.92776314799643977,3936]

{"sheet":"Sheet7","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using RAND, INDEX, RANK.EQ Functions"]
[]
[null,"Salesman","Random Value","Sales",null,"Random Cells"]
[null,"Mike",0.88085038756985834,1540,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C5,$C$5:$C$12),1)","v":"Mike"}]
[null,"Adam",0.66910436884507862,4637,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C6,$C$5:$C$12),1)","v":"David"}]
[null,"David",0.113730721975558,4350,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C7,$C$5:$C$12),1)","v":"Steve"}]
[null,"Hopper",0.56072194344181547,3625,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C8,$C$5:$C$12),1)","v":"Hopper"}]
[null,"Stuart",0.42037441233602024,2735,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C9,$C$5:$C$12),1)","v":"Stuart"}]
[null,"Milford",1.9819259201944162E-3,8235]
[null,"Steve",0.6884853441763924,1524]
[null,"Bob",0.27699224465288419,3936]

{"sheet":"UNIQUE,RANDARRAY,INDEX,RANK.EQ","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using UNIQUE, RANDARRAY, INDEX, RANK.EQ Functions"]
[]
[null,"Salesman","Random Value","Sales",null,"Random Cells"]
[null,"Mike",6.45988515556202,1540,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C5,$C$5:$C$12),1)","v":"Hopper"}]
[null,"Adam",3.5236433451749516,4637,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C6,$C$5:$C$12),1)","v":"Steve"}]
[null,"David",6.2908154494040964,4350,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C7,$C$5:$C$12),1)","v":"Stuart"}]
[null,"Hopper",7.7682071476324808,3625,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C8,$C$5:$C$12),1)","v":"Mike"}]
[null,"Stuart",2.5185632045648223,2735,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C9,$C$5:$C$12),1)","v":"Bob"}]
[null,"Milford",5.1401659668396,8235]
[null,"Steve",6.4928762307110102,1524]
[null,"Bob",7.6898093616309087,3936]

{"sheet":"RAND,INDEX,RANK.EQ,COUNTIF","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using RAND, INDEX, RANK.EQ, COUNTIF Functions"]
[]
[null,"Salesman","Random Value","Sales",null,"Random Cells"]
[null,"Mike",0.82096700059646255,1540,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C5,$C$5:$C$12)+COUNTIF($C$5:C5,C5)-1,1)","v":"Adam"}]
[null,"Adam",0.8089533934092985,4637,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C6,$C$5:$C$12)+COUNTIF($C$5:C6,C6)-1,1)","v":"David"}]
[null,"David",0.59826012021486918,4350,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C7,$C$5:$C$12)+COUNTIF($C$5:C7,C7)-1,1)","v":"Hopper"}]
[null,"Hopper",0.29841453557934083,3625,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C8,$C$5:$C$12)+COUNTIF($C$5:C8,C8)-1,1)","v":"Milford"}]
[null,"Stuart",0.55065395176157783,2735,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C9,$C$5:$C$12)+COUNTIF($C$5:C9,C9)-1,1)","v":"Stuart"}]
[null,"Milford",0.17882539735528535,8235]
[null,"Steve",0.87981603645961681,1524]
[null,"Bob",0.19422270465538172,3936]

{"sheet":"INDEX,RANDARRAY,ROWS,SORTBY,SEQ","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of INDEX, SORTBY, RANDARRAY, ROWS, SEQUENCE Functions"]
[]
[null,"Salesman","Sales",null,"Random Cells"]
[null,"Mike",1540,null,{"$f":"INDEX(_xlfn.SORTBY(B5:B12,_xlfn.RANDARRAY(ROWS(B5:B12))),_xlfn.SEQUENCE(5))","v":"Adam"}]
[null,"Adam",4637,null,"Milford"]
[null,"David",4350,null,"Stuart"]
[null,"Hopper",3625,null,"Hopper"]
[null,"Stuart",2735,null,"Bob"]
[null,"Milford",8235]
[null,"Steve",1524]
[null,"Bob",3936]

{"sheet":"Sheet6","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using RAND, INDEX, RANK.EQ Functions"]
[]
[null,"Salesman","Random Value","Sales",null,"Random Cells"]
[null,"Mike",0.65511721973760251,1540,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C5,$C$5:$C$12),1)","v":"David"}]
[null,"Adam",0.24620500481406815,4637,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C6,$C$5:$C$12),1)","v":"Bob"}]
[null,"David",0.67613026251988806,4350,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C7,$C$5:$C$12),1)","v":"Adam"}]
[null,"Hopper",0.44513368229836947,3625,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C8,$C$5:$C$12),1)","v":"Steve"}]
[null,"Stuart",0.52432887368482006,2735,null,{"$f":"INDEX($B$5:$B$12,_xlfn.RANK.EQ(C9,$C$5:$C$12),1)","v":"Hopper"}]
[null,"Milford",0.52189291654568082,8235]
[null,"Steve",0.77869020670903433,1524]
[null,"Bob",0.4829201498773833,3936]

{"sheet":"VBA Code","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Code"]
[]
[null,"Salesman","Sales",null,"Random Cell"]
[null,"Mike",1540,null,"Bob"]
[null,"Adam",4637]
[null,"David",4350]
[null,"Hopper",3625]
[null,"Stuart",2735]
[null,"Milford",8235]
[null,"Steve",1524]
[null,"Bob",3936]