excelFan

Posts: n/a

counting non occur entries

hi all,
i have two lists L1 in the range A2:A30 and L2 in the range K15:K240, like
to know the number of occurrences in L1 which do not occur in L2.
thanks for any help

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
Automatic changes in cell entries	doco	Excel Discussion (Misc queries)	3	December 12th 04 04:23 PM
Multiple Files, Duplicate Entries	PMSunshine77	Excel Discussion (Misc queries)	1	December 10th 04 08:28 PM
Counting rows based on criteria in multiple cells	Margaret	Excel Discussion (Misc queries)	11	December 2nd 04 11:04 PM
Counting question	sjs	Excel Discussion (Misc queries)	5	December 2nd 04 09:24 AM
Counting Repeated text or duplicates in a list	Repeatdude	Excel Discussion (Misc queries)	5	November 26th 04 07:10 PM

All times are GMT +1. The time now is 10:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us