Extragere cuvinte unice

Question

459 viewsJanuary 11, 2021Intrebari

0

George 12 January 11, 2021 0 Comments

Buna seara,

As avea nevoie de putin ajutor.
Sunt incepator in excel, folosesc excel 365, si as dori sa ma ajutati ca sa extrag cuvintele unice dintro coloana si apoi sa le pun in ordine alfabetica.

Multumesc anticipat.

Indigo Answered question January 11, 2021

1 Answer

Indigo · Answer 1 · 2021-01-11T15:24:42+00:00

Salut,

In excel 365 este functia UNIQUE.
In cazul tau formula ar fi:
=UNIQUE(A1:A5000) apoi daca vrei si sortare, foloseste:
=SORT(UNIQUE(A1:A5000))

Evident, inlocuieste range A1:A5000, cu range tau.
Ex: E2:E1500 sau D2:D15000