Require Macro to get data in separate column

This offsets the cells into the next column

Please Login or Register  to view this content.

Duplicate post from https://www.excelforum.com/showthread.php?t=1037475
I knew this data looked familiar..

..and what about the other names? What are the rules and how are they presented?

Better still re-upload the workbook with a complete set of results and confirm which cells are data and which are results.

Originally Posted by sriku

Hi Richard,

I require only Ram, Mohan, Gopal to be taken in separate column and remaining will retained in the same rows.

Please help on this.


Thanks,

Hi,

That's different to your example workbook where you specify only Mohan & Krishna

However in general you need in B2 copied down

Formula:

Please Login or Register  to view this content.

add or delete names in the OR clause as necessary