txheart

Junior Member

Posts: 21

Quote:

Originally Posted by wickedchew

The COUNTIF function is:

=COUNTIF(Range, Criteria)

Range is where you have a list to be checked and Criteria is what needs to be looked for in your list.

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

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 02:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us