Posted to microsoft.public.excel.misc

milkbonemom milkbonemom is offline

external usenet poster

Posts: 3

Finding duplicates

I'm trying to find if the row in column B and C matches the row aboe and if
so put dupl in the cell in column A.
=IF(B2andC2=B1andC1,"dupl","")
The information in each column is text so I didn't use +. Any suggestions?

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
Finding Duplicates	Karen	Excel Discussion (Misc queries)	4	April 7th 08 10:47 PM
Finding Non-Duplicates	calibansfolly	Excel Worksheet Functions	2	July 16th 07 04:40 PM
Finding duplicates	Stephanie	Excel Discussion (Misc queries)	5	April 10th 07 09:10 AM
Finding duplicates	Ted Metro	Excel Worksheet Functions	2	November 21st 05 07:09 PM
Finding Duplicates	nospaminlich	Excel Worksheet Functions	4	February 5th 05 11:57 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us