Forum Discussion
Filter Advanced / Multiple criteria / non contain
MarcoTorinoi Please see the attached workbook with the list of email provider domains arranged horizontally. With such a huge criteria list, performance may be an issue when applying it to a large dataset. You'll just have to test it to see how well it performs...
Thanks.. the issue is that I have tried to transpose from vertical to horizontal the list of the private emails (https://gist.github.com/ammarshah/f5c2624d767f91a7cbdc4e54db8dd0bf ) and gives an error.
It is probably because Excel can not transpose a list of 6000 items...
MarcoTorinoi Please see the attached workbook with the list of email provider domains arranged horizontally. With such a huge criteria list, performance may be an issue when applying it to a large dataset. You'll just have to test it to see how well it performs...
MarcoTorinoi I'm not exactly sure where you went wrong with the copy/paste procedure. This is what I did:
- import the list into column A (range A1:A6104)
- add the "does not contain" syntax using a formula in cell B1 (="<>*"&A1&"*") and copy it down (range B1:B6104)
- select the entire list in range B1:B6104 and press Ctrl+C to copy
- select cell C1 and press Ctrl+Alt+V to open the Paste Special dialog box
- select "Values" and "Transpose" and click "OK"
Paste Special Values > Transpose
- Thanks.. I did the same. but I succeed to transpose a maximum of 250 items. Not sure why,