Spreadsheets get unique names but ignore blank cells December 7, 2023 by Tarik =unique(A2:A) should work =unique(filter(A2:A,A2:A<>"")) to also ignore blanks