NV Form Ranger Add-on

Contact owners and managers
1–30 of 880
See example for duplicate items in the list. Read the posts starting at the above link. Google made a change and any duplicates will cause the update to fail.

=sort(unique(arrayformula(trim(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2:B," "," ")," "," ")," "," ")))),1,true) will locate and remove any duplicates.

Welcome to the Form Ranger Community forum!

Before posting a new question, please use the search tool to check past discussions!
If you are reporting a bug or error, please strive for as much clarity and detail as possible, include screenshots when applicable. 

This tool is free and maintained by a very small team at an educational non-profit. We rely on this community to help diffuse the support load, so if you see an issue you can help with, please do so. Thank you!