detect the numbers of the two sectors *

**jorel** · 07-03-2019, 05:27 PM

detect the numbers of the two sectors
* detect the numbers according to the two topics
* in each draw line then join the two
https://www.excelforum.com/attachmen...1&d=1562189210

**Kaper** · 07-04-2019, 06:15 AM

Q6:

Formula:

Please Login or Register  to view this content.

AE6:

Formula:

Please Login or Register  to view this content.

copy both formulas right and down as needed

**Kaper** · 07-04-2019, 06:46 AM

And if you prefer to have it done with macro (as you posted question in this sub-forum) you can use:

Please Login or Register  to view this content.

**jorel** · 07-04-2019, 08:32 AM

huu! hello KAPER, perfect, conglatulations!!! thany you!!

Re: detect the numbers of the two sectors *