| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding duplicate values b/w two columes
Is there any way i can find duplicate cells between two columes. i have to see these duplicate value in lots of columes it will take a long time to do it manually.  -- nikki115 ------------------------------------------------------------------------ nikki115's Profile: http://www.excelforum.com/member.php...o&userid=35221 View this thread: http://www.excelforum.com/showthread...hreadid=549919 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding duplicate values b/w two columes
Hi
Try searching this newsgroup with "find duplicate values in two ranges". You should find something useful. Anything by Tom Ogilvy especially, on this kind of thing, is sure to be neat as he probably has a simple worksheet function that will do what you want. regards Paul nikki115 wrote: Is there any way i can find duplicate cells between two columes. i have to see these duplicate value in lots of columes it will take a long time to do it manually. -- nikki115 ------------------------------------------------------------------------ nikki115's Profile: http://www.excelforum.com/member.php...o&userid=35221 View this thread: http://www.excelforum.com/showthread...hreadid=549919 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding duplicate values b/w two columes
Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm nikki115 wrote: Is there any way i can find duplicate cells between two columes. i have to see these duplicate value in lots of columes it will take a long time to do it manually. -- nikki115 ------------------------------------------------------------------------ nikki115's Profile: http://www.excelforum.com/member.php...o&userid=35221 View this thread: http://www.excelforum.com/showthread...hreadid=549919 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trouble Finding Duplicate Values with Conditional Formatting | Excel Discussion (Misc queries) | |||
| Finding Duplicate Values | Excel Worksheet Functions | |||
| hiding columes | New Users to Excel | |||
| Finding Duplicate values within a single column | Excel Programming | |||
| Problem finding duplicate values | Excel Programming | |||
Linear Mode
