Need small formula correction please

[serge]

Hi All,

I need a small help to make this formula work.

I have in :

A1= 3
A2= 5
A3= 2
A4= 9
A5= 8

And in :

A7,A8,A9,A10 this formula :
=MATCH(0,FREQUENCY(A$1:A6,{1,2,3,4,5,6,7,8}),0)

which give the missing digits from A1:A5.

My question is what need to be change in this formula to work for the row:
A1,B1,C1,D1,E1.

Thank you all. Serge.

 

[serge]

Marcelo,

Your last formula works perfectly, thank you so much for your help ,I really appreciate it.

 

[serge]

Haseeb Avarakkan,

Yours too work fine,Thank you very much.

The only thing is that it doesn't get the " 0 " as the missing digits ??

SO IF I have the following numbers :

A1:E1. 2,20,24,27,33.

Your formula will give me the following missing digits :

1,5,6,8,9 which those are the right digits, BUT is missing the " 0 ". Thank you.