Hi Experts,

Im using =UNIQUE(A1:A100) to extract unique data. Can we modify the formula in such a way that if i add another 50 texts in column A, the formula will adjust automatically to =UNIQUE(A1:A150)??


Thank you,