Posted to microsoft.public.excel.programming

scrabtree23[_3_] scrabtree23[_3_] is offline

external usenet poster

Posts: 55

non-duplicated values

I have data in columns A and B on spreadsheet one. I need a macro that will
look down column B and then look down column A and list in column C only the
values that are not duplicated in both columns A and B. In other words, I
need the unduplicated items to be listed in column C.

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
Delete rows with duplicated values	Emece	Excel Discussion (Misc queries)	2	April 16th 09 12:52 PM
Formula to check duplicated values	Mary	Excel Discussion (Misc queries)	2	March 2nd 07 01:46 PM
duplicated values	baha	Excel Discussion (Misc queries)	2	December 10th 06 11:11 PM
How to delete duplicated values in each row ???	Oleg	Excel Discussion (Misc queries)	2	March 8th 06 12:57 PM
To find duplicated values in a range	beechum1	Excel Worksheet Functions	1	February 10th 06 04:31 AM

All times are GMT +1. The time now is 11:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us