Show Data Without Repetition with the exception of a Word

[deciog]

Gentlemen, I need a solution.

I need column D3 to show all the data of clone B3: B20, but does not show word "complete"

Use only formulas, Excel 2016

Thank you very much in advance

 

[Hui]

Select B3:B9
Goto the Data, Advanced Filter tab


Get:

Excel thinks the first Complete is a heading, ignore or delete it

 

[PCosta87]

Hi @deciog

Using only formulas you can have normal formulas or array formulas... please see attached

You can set what you want to exclude in D2 or E2 (depending which formula you prefer)... you can always hide or set text to white if it can't be visible

Hope this helps

 

[deciog]

Hui, Thanks but I need formulas.

PCosta 87, excellent very good, that's right, thanks

To both obliged for the help

Hugs
Decio

 

[PCosta87]

Hui, Thanks but I need formulas.

PCosta 87, excellent very good, that's right, thanks

To both obliged for the help

Hugs
Decio

Don't mention it