Formula Help missing digits

[serge]

I have the following values in the following cells:

A1 = 2
A2 = 12
A3 = 34
A4 = 44
A5 = 53


And in A6 this formula :


=MATCH(0,FREQUENCY(A$1:A5,{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55}),0)-1


1st question :

What need to be change to NOT have a " 0 " starting the list of the missing numbers but a 1.

2nd question :

Also what need to be change for me to have this formula starting in cell : A7 and not have duplicate digits,

Thank you all in advance for your valuable assistance.

 

[barry houdini]

Try this version in A7

=MATCH(0,FREQUENCY(A$1:A6,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55}),0)

or you can shorten like this

=MATCH(0,FREQUENCY(A$1:A6,ROW(INDIRECT("1:55"))),0)

 

[serge]

Thanks very much Barry for your quick and accurate response.
Serge.