Forum Discussion
How to match two columns that have common values together
Greetings Comm! I have a case where I have a common number between 2 columns in a sheet and I want to link them together, so as shown below for example FileX 231 in column A to be in front of 231...
I think you need to combine two formulas: MID and FILTER there. But, if you upload that file with one tab with your problem... And in another tab, you put the solution manually. I can produce the solution using formulas and share that with you
ricardojose Hello, here's the link for the sample file I made:
https://1drv.ms/x/s!Alq4caKydpVMoFU76XFRX8vOwmzw
Appreciating your help!
