Posted to microsoft.public.excel.misc

Jason K

external usenet poster

Posts: 1

counting

I am trying to see if a policy number (ex. ml001122) appears on a sheet. I
have a list of about 300, and want to know if they appear on another sheet
and how many times they appear. I have tried using the formula
=COUNTIF('SHEET1'!A1:'SHEET1'!A2500,A1) but it keeps coming back as 0. The
first sheet has more than two thousand rows, and on the second sheet I have
about 300 policy numbers to check. I need to see if those numbers are on the
first sheet.

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
Counting once more	JRD	Excel Worksheet Functions	2	December 12th 07 06:38 PM
counting function but not double counting duplicates	JRD	Excel Worksheet Functions	2	November 7th 07 06:43 PM
counting help	Mike	Excel Worksheet Functions	3	April 20th 07 07:28 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 01:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us