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,
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,
If I've helped U pls click on d *Add Reputation
Please tryFormula:Please Login or Register to view this content.
Thanks for the rep . Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks