Formula to display unique entries

Options

I have a form that is tied to a source sheet and I have a separate data sheet where I am trying to obtain data on the list of cities. Is there a formula I can use to display the unique entries on a data sheet in column form based on what is input on the source sheet? Would this be sensitive to whether the cities are typed with capitals or not capitals? Example, would City of Chesapeake and city of chesapeake both be seen as the same?

Ex: I would want to see a list for all unique entries as the one below:

City of Chesapeake

City of Manassas

City of Suffolk

City of Waynesboro

etc.

Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!