Posted to microsoft.public.excel.programming

[email protected] wrethams@gmail.com is offline

external usenet poster

Posts: 17

conditional merging of two columns?

I want to merge the two columns, sample data below:

CNM1GBLO #N/A
CNM1GBLO #N/A
CNP1GBLO #N/A
CNP1GBLO NIMWGBLO
CNQ1GBLO #N/A
CNR1GBLO #N/A
CNR1GBLO #N/A

What I want is for any value in the righthand column which is not
equal to #N/A to overwrite the value in the lefthand column on the
corresponding row.

So in this case, after the merge, column A would remain the same,
except that CNP1GBLO would now overwritten with NIMWGBLO.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merging Columns	Titanium	Excel Worksheet Functions	13	May 31st 10 09:36 PM
Conditional Merging	Tony L	Excel Discussion (Misc queries)	0	August 24th 07 02:14 PM
merging columns	Todd Hudson	New Users to Excel	2	June 4th 06 05:49 PM
Merging Columns	HELP, Trying to more proficient here	Excel Worksheet Functions	1	April 11th 06 03:20 PM
Merging Columns	cbrd[_31_]	Excel Programming	0	January 11th 06 10:03 PM

All times are GMT +1. The time now is 08:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us