Google Form with verification numbers tutorial template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
775414877541483459977Explaination
2
512580151258014342260
A = random vericfication numbers //=round(RAND()*10000000)
3
876838287683825868414B = only using unique numbers from A //=UNIQUE(A:A)
4
690809069080904076117
C = copy the unique numbers from B using "values only"
5
669589866958983851968
6
991140899114087429954Column C is used for data validation in Form responses
7
774463277446325984234
8
207165920716591210071
9
980362098036202400148
10
852540885254086541163
11
266398126639816878244
12
278808227880827251796
13
376144937614492953708
14
377587437758743955175
15
583681658368161966133
16
358635867556292
17
190239219023924119945
18
527072052707204547094
19
481487548148757868510
20
634657663465762363764
21
766006376600634797005
22
516987551698754513679
23
378125037812507433039
24
738357473835744721685
25
351557735155771325525
26
853148485314849956394
27
808219780821972933209
28
575671557567151085275
29
92900029290002770331
30
957572895757285330696
31
915445891544587327691
32
937496893749688276706
33
364254436425441677220
34
121516012151607837388
35
476784247678422762937
36
476292847629288820285
37
4568904568902109999
38
153841815384188221590
39
998131099813103668365
40
191511319151131546542
41
743291574329159820402
42
758451375845135886133
43
750185275018529039285
44
756039075603904103202
45
764821776482178254324
46
37078143707814907056
47
223891822389185591405
48
961026296102629677194
49
611371161137111646192
50
910922091092202215547
51
376322537632252894169
52
674639267463925137899
53
241977524197753586345
54
669692366969233402587
55
210724421072445930892
56
359691435969144203756
57
745421974542194836858
58
334053633405362756936
59
688570568857056454063
60
375766237576624893613
61
68705956870595609013
62
979525097952509224536
63
706797070679707553383
64
33646336463167120
65
649514764951474784853
66
709810970981094466818
67
890012689001261440557
68
370771737077172217162
69
518295751829573507510
70
507632050763201068897
71
245319824531982588951
72
238749623874965552853
73
876861787686177510066
74
77579807757980283782
75
306485830648585429501
76
903830590383051182316
77
470401147040114785934
78
993842699384263430971
79
254554525455454877652
80
317896931789699789384
81
735567735567802547
82
893084889308486075975
83
643593664359365093681
84
889898788989875884311
85
254559925455994262521
86
561767556176758295688
87
783118578311856564027
88
334972733497276757835
89
466712546671257338014
90
931965093196508274978
91
532841453284148221240
92
366893936689397022474
93
617882061788202605643
94
171237717123773919190
95
250741125074113844897
96
991700899170086338864
97
7696512769651276903
98
604553560455354251425
99
902052790205275923171
100
653502465350245028491
Loading...
 
 
 
TAN generator
autoCrat_MergeData_DO_NOT_DELETE
mail merge
NVScriptsProperties
Form responses 1