Get Max and Min and unique text from different cells

[Wox17vba]

Hello all,

I have a problem making an Excel formula. There are two cases:

First:
I have a different data in some cells (that cells are text type):

2% ---- 3% ----- 1,5%-5% ---- 2,5% ----- 7%

I need to know how can I get minium and maximum value of all of these information. In that case solution was: 1,5% - 7%
You can see that data is possible to find only one value or range of values.

Second:
It's similar problem but this time with "words".
Exemple:
hello ----- test ----- house ---- test ----- car ----- car2

In that case I would need to get a cell with result without any duplicate word: In the example above it was: hello - test - house - car - car2

I think that could made with vba code but I would like to know if is possible only applying excel formulas.

Thank you very much.

[samba_ravi]

pls attach a sample excel fine with desired result

[Wox17vba]

Hello!

I add a snapshot and excel file.


example.JPG

Thank for your answer!

[Wox17vba]

Any help??