Hello Colin,

Thank's a lot for your answer

Just to bring the whole picture (because this is just a part of it), my database has 5 columns with phone numbers, some correct, some incorrect. I added 5 columns which calculates whether this numbers are correct (values greater than 0) or incorrect (values = 0) - this columns are presented in the sample data.

After I get the cells where the values are correct, I use the OFFSET function to extract the phone numbers from the corresponding columns.

I know this is weird, but I did it in order to test my array understanding (At first look, I come with a simpler solution).

If you think it is worth to bring the VBA solution (maybe there will be other people finding it interested).....

Thank you also for the links I will carefully look at them

Regards,
Andrei