mukesh verma

mukesh verma

  • NA
  • 15
  • 560

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

Nov 11 2022 8:27 AM

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.

Numer 1 number 2 how many numbers in both cell?
1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9 1.6, 1.7, 1.8, 1.9, 1.15, 1.16, 1.17, 1.18, 1.19 1.6, 1.7, 1.8, 1.9

Answers (3)