Excel Analytics : Replace values in the 2nd column

[mastermind11]

As you can see, there are four columns with numbers in the image, the first column has numbers in sequence, and the 2nd column has numbers from 1-8 that are non-zero.Now, the 4th column is the filtered 1st column, and the 5th column has no non-zero numbers.

What I want is for the numbers from the 5th column to paste by replacing zeros in the 2nd column for the corresponding ColA values. The 1st column again is a sequence of numbers and the numbers from 4th column are further down in the 1st column.

I hope this makes sense. Look at first eight rows for clarification. Please tell me a function that will do the job for me. I really need something like that.

Much appreciated.Thanks!

Capture.PNG

[Pepe Le Mokko]

Thank you for the picture. However, a sample file would be much easier to work with. Thank you

[mastermind11]

Do you want a sample file or are you okay. Because I would need to recreate it.

[Pepe Le Mokko]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.excelguru.ca/forums/showt...ed=1#post21400
http://www.mrexcel.com/forum/excel-q...ml#post4362460
https://stackoverflow.com/questions/...the-2nd-column

[mastermind11]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.excelguru.ca/forums/showt...ed=1#post21400
http://www.mrexcel.com/forum/excel-q...ml#post4362460
https://stackoverflow.com/questions/...the-2nd-column

Unfortunately, I have to do that because no one is willing to help. Why don't anyone help. What sucks is when anyone else needs help, I instantly help, but when it is my turn, every backs out. That is just unfair.

[Pepe Le Mokko]

No one ever pretended cross-posting is not allowed. What is not allowed is cross-posting without links to your posts on other forums. You will find that all forums have this policy. ( I suppose you read the link provided).
As you can see, this has an adverse effect on help people are willing to give.

Also, pleasedon't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.