wickedchew wickedchew is offline

Senior Member

Location: Philippines

Posts: 161

Quote:

Originally Posted by txheart

According to your reply, if the don't duplicate data is in range E4:E200 my formula should be =COUNTIF($E$4:$E$200,E4)=1
correct?

Thank you for helping Wicked!

~Ky

Thank you for your help Wicked

If the COUNTIF function outputs a value more than 1, hence there are duplicates within the list.

__________________
Asobi Wa Owari Da

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
Condensing a list with duplicates to a list with non-duplicates	Nuclear	Excel Worksheet Functions	2	July 29th 08 08:03 PM
Duplicates in excel that aren't 100% DUPLICATES ...	[email protected]	Excel Discussion (Misc queries)	4	May 2nd 08 06:43 PM
Duplicates - not all the same	blander	Excel Discussion (Misc queries)	1	July 28th 06 01:44 PM
Duplicates	Alex	Excel Discussion (Misc queries)	0	May 20th 05 07:22 PM
Duplicates	bj	Excel Discussion (Misc queries)	0	May 20th 05 07:21 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us