Extract Unique Values From Row

[AV114]

Hey, I Want To Extract One Value From The Row and Result should be like below

1​	2​	3​	4​	5​	6​	7​	8​	9​	10​		Result
Immediately	Immediately	100 Days	75 Days	100 Days	45 Days	60 Days	On Delivery	On Delivery	45 Days		Immediately,100 Days,75 Days,45 Days,60 Days,On Delivery

 

[Belleke]

You should post a little example instead of pictures.
If the above numbers are the columns A->L then try this formula in column L

=B1& ","&C1&","&D1&","&F1&","&G1&","&H1

 

[Fluff13]

How about

Function AV_114(Rng As Range) As String
   Dim Cl As Range, x
   With CreateObject("scripting.dictionary")
      For Each Cl In Rng
         If Cl.Value <> "" Then .Item(Cl.Value) = Empty
      Next Cl
      AV_114 = Join(.Keys, ", ")
   End With
End Function

Used like
=AV_114(A2:J2)

 

[Nebu]

Hi:

If you are using any of the latest versions of excel you can achieve this easily using power query.

Thanks

 

[Peter Bartholomew]

… or using modern Dynamic Arrays

Why wasn't it always like this???