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