Forum Discussion
Transferring specific numbers from a column to a column
Hi Mtumushi
If I understand the requirement correctly, you need below formula:
=IFERROR(INDEX($A:$A,MATCH(COLUMN(),$A:$A,0),1),"")
Please let me know if it works for you. A sample file is also attached for your reference.
Thanks
Tauqeer
Hi Mtumushi
If I understand the requirement correctly, you need below formula:
=IFERROR(INDEX($A:$A,MATCH(COLUMN(),$A:$A,0),1),"")
Please let me know if it works for you. A sample file is also attached for your reference.
Thanks
Tauqeer
Thank you very much tauqeeracma. It has perfectly work
I'm surprised - tauqeeracma's formula, however nice, does something completely different from what you asked...
Hi HansVogelaar
Your VBA code was excellent and exactly producing the desired result but @Mtumushi was interested in non-VBA solution and he wanted the solution directly in his file through email.
Thanks
Tauqeer
- Thanks but this may only work if each cell has a single number... What is it has multiple numbers?
Can you confirm what is the range of multple numbers, I mean the range is 1 to 9 (single digit) or it can be any number for example 312, 7123 etc.
Thanks
- The numbers are 3,4,7,9, in a single cell and basically what I need is to transfer as they are to column 3,4,7 and 9
- Let me try it out.. I will inform you if it works
