Use a nested loop why so low efficiency, spent nearly 10 seconds to complete, but the use VBA almost instantly, please have a look, to guide the novice , detailed see screenshot