Check decimal number in 2 cell and copy in another cell with matched.

Vishal ji, Thanks for answer but Data is coming randomly using another formula and i want only Excel Formula.

I already use below formula. = TEXTJOIN(",",TRUE,IFERROR(IF(FIND(TEXTSPLIT($A$1,",",,TRUE,1,),$B$1)>0,TEXTSPLIT($A$1,",",,TRUE,1,),0),"")). but answer came 1.7, 1.8, 1.9 

Hello

You can use Intersect. please check below sample code.

static void Main(string[] args)
        {
            try
            {

                string A1 = "1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9";
                string B1 = "1.6, 1.7, 1.8, 1.9, 1.15, 1.16, 1.17, 1.18, 1.19";
                string C1 = string.Empty;

                decimal[] arrA1 = A1.Split(",")?.Select(decimal.Parse).ToArray();
                decimal[] arrB1 = B1.Split(",")?.Select(decimal.Parse).ToArray();
                decimal[] arrC1 = arrA1.Intersect(arrB1).ToArray();

                C1 = string.Join(",", arrC1);

                Console.WriteLine("Numbers in both cell: " + C1);
            }
            catch (Exception e) when (e is Win32Exception || e is FileNotFoundException)
            {
                Console.WriteLine("The following exception was raised: ");
                Console.WriteLine(e.Message);
            }
            Console.ReadLine();
        }

Thank You

any idea??