I am looking for a function to collect drop-down value used in a column, and saved in a cell.
For example, on "Types" column, it has "Type A"-"Type B" as a list, whatever the list value used in each row, I want to store used ones in the first row.
If I'm understanding you correctly, you have a column with multiple options to select, and this column may have the same option selected more than once. However, you want one summary cell that returns each of the Types selected, once.
If so, I you can build an IF(HAS statement for each Type, which would return the name of the Type if it's present in the column. Then you can add all these IF statements together. You'll notice I added + " " to add in a space between the types, as well.
=IF(HAS(Types:Types, "Type A"), "Type A") + " " + IF(HAS(Types:Types, "Type B"), "Type B") + " " + IF(HAS(Types:Types, "Type C"), "Type C")... etc
I input this formula in a column next to it so that I could easily reference the entire column by writing Types:Types. If you want to have this formula in the same column, you will need to adjust the reference to have a start-row and an end-row, such as the following: Types11:Types35
Here are some Help Center articles I used: IF function / Joining Text in Formulas / HAS function / Column References in formulas
Let me know if this works for you!
Are you a genius? 😍😍
Haha! You're welcome - glad that it worked for you. 🙂