i have spreadsheet looks that:

i want distinct sections, in fact distinct first string section colume. tried advanced filters however, gives me whole string. there excel formula check columes first string?(like here: bla, blub, bla1, bla2, blue)
i appreciate answer!
in excel, add new column with:
=left(b2,find(" ",b2)) that give list of first words; after can use filters.
Comments
Post a Comment