How to see if I have jumps in a consecutive ?

[KarenHM]

Hi communiy 

I need create a formula that allow me identify is I have in a range a consecutive number lost. Here the example, in this range I have lost the number 38369

Many thanks 

[alexnajm · Accepted solution]

Hi @KarenHM,

The Multi-Row Formula tool is best here - make sure you sort beforehand though!

-Alex

[binuacs · Accepted solution]

@KarenHM One way of doing this

[KarenHM]

Many thanks for your help :)