I have 2 Cell with string. in A1 i have a 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9 and in B1 i have a 1.6, 1.7, 1.8, 1.9, 1.15, 1.16, 1.17, 1.18, 1.19. i need a formula to copy all decimal number which is available in both cell. that means in cell A1 and in Cell B1 there are same number is 1.6, 1.7, 1.8, 1.9. So, in C1 answer should be 1.6, 1.7, 1.8, 1.9.
is any one have a formula for this. Please reply. Only formula without VBA code.