If you want to play a bit and see how many options you want to scan, you can delete contents from F column right and run such short macro (BTW - isn't it pretty? :lol: ):
You can start with small maxicol value (say 2 or 3 - and you shall have result ready in few seconds - depending on your machine speed). 100 was on mine around 3 minutes. I've not tested higher values, but if you have some spare time - you may do so. Of course excel will crush if you choose some 2728+ or so, because of trying to write right to XFD column . It could crash also earlier, because of for instance insufficient resorces for instance.
Please share your findings!
Bookmarks