Forum Discussion

Copper Contributor

Mar 11, 2021

Solved

Transferring specific numbers from a column to a column

How do I move the specific numbers to a column that correspond to the numbers.. Kindly assist For example 1,2,3,5,9 and they are about 500 and I want to copy for example 9 to column 9..

excel

tauqeeracma
Mar 11, 2021
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
Transferring specific numbers from a column to a column.xlsx8 KB

tauqeeracma

Iron Contributor

Mar 11, 2021

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

Transferring specific numbers from a column to a column.xlsx8 KB

Mtumushi

Copper Contributor

Mar 12, 2021

Thank you very much tauqeeracma. It has perfectly work

HansVogelaar
MVP
Mar 12, 2021
Mtumushi

I'm surprised - tauqeeracma's formula, however nice, does something completely different from what you asked...
- tauqeeracma
  Iron Contributor
  Mar 12, 2021
  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
  - HansVogelaar
    MVP
    Mar 12, 2021
    tauqeeracma
    
    Ah, OK.
- Mtumushi
  Copper Contributor
  Mar 12, 2021
  HansVogelaar I had no idea what it was... Thank you.. You really assisted