Formula to display unique entries

Rabia

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

BullandKhmer

You need to explaion yourself better.

Are you asking for a formula to return a list of rows where X city is listed in 'select town permits'.

Rabia

@BullandKhmer

I am basically looking for a formula to display all the unique entries in a separate sheet that are listed in the column called "Select City or Town Permits"

Does that make sense?

BullandKhmer

You want all unique entries in the column?

Rabia

Yes, that is correct @BullandKhmer

Genevieve P.

Hi @rabia

The easiest thing to do here is use a JOIN function to Join together all your multi-select values from one column into one multi-select cell. This will automatically strip out any duplicates!

Here's an example in the same sheet:

However you can do this in a cross-sheet formula, like so:

=JOIN({Multi Select Column}, CHAR(10))

The CHAR(10) is the break between multi-select values.

This would indeed be case-sensitive, because a lower case value typed would be selected as a new selection in your multi-select column.

Let us know if that helped!

Cheers,

Genevieve

Rabia

Hi @Genevieve P.,

Thank you, yes the Join function works well for this, but is there a way for me to then take those unique entries in the single cell and have each of them displayed in separate rows?

Similar to this:

Genevieve P.

Hi @Rabia

There currently isn't a direct way with a formula to parse out a multi-select cell into multiple, individual rows. Please vote on this Enhancement request post to add your voice to this Idea!

Rabia

Hi @Genevieve P., I did vote on that post! I appreciate your help.