Posted to microsoft.public.excel.misc

Faraz A. Qureshi Faraz A. Qureshi is offline

external usenet poster

Posts: 211

Counting ISNAs?

I want to check how many of the entries in A1:A10, are not found to be
existing in another list, suppose B1:B20.

Tried out:

=SUMPRODUCT(--(ISNA(VLOOKUP(A1:A10,B1:B20,1,0))))

but failed. What might be the reason? and what might be its solution except
then a helper column?

--
Best Regards,

Faraz

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
counting function but not double counting duplicates	JRD	Excel Worksheet Functions	2	November 7th 07 06:43 PM
Counting down	Bikertyke	Excel Worksheet Functions	5	December 6th 06 11:45 PM
need help with counting...	fiur	Excel Worksheet Functions	4	November 13th 06 05:47 PM
Counting rows, then counting values.	Michael via OfficeKB.com	Excel Discussion (Misc queries)	7	August 4th 05 10:57 PM
Counting names in a column but counting duplicate names once	TBoe	Excel Discussion (Misc queries)	9	May 11th 05 11:24 PM

All times are GMT +1. The time now is 07:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us