using a formula simlare to UNIQUE to create a list from a column of filled cells

Question

I'm trying to figure out how to auto populate a list from a column with filled/empty cells. I know UNIQUE will populate a list, but sometimes the values are the same, and I need each cell with data to show up in the list.

detlef_lewin · Answer

Byron-CityScape_Balt&nbsp;You spelled FILTER() wrong.&nbsp;

byron-cityscape_balt · Answer

Thanks&nbsp;for catching that!&nbsp;&nbsp;Detlef_Lewin&nbsp;

Forum Discussion

using a formula simlare to UNIQUE to create a list from a column of filled cells

Share

Resources