Hi Matthew,
This may be a typo, but some non-english versions of excel and some
Macintosh versions
of Excel require a semicolon - ; - instead of a comma - , - in some
places, along with
some other variations.
Dave.
MatthewTap Wrote:
Stefi --
Thanks for the formula... that helped me a lot.
One thing I did find, though, and I can't stress enough that I'm just
trying
to help Paul by pointing this out, but there was an innocent typo in
the
COUNTIF from the post. [it could be that it's not a typo and I'm just
not
entirely sure I know exactly what I'm doing... just trying to learn
what I
can from here.
Anyway, I took your formula and played around with it for awhile,
learning a
lot in the process, then figured why I was getting an error. The
formula
from the original post:
=COUNTIF(Sheet2!B:B;A1)
the formula I got to work:
=COUNTIF(Sheet2!B:B,A1)
[Essentially, all that yammering to say that mine only worked with a
comma
in front of A1, whereas yours had a semi-colon. So, just something to
try
out.
Bottom line though, thanks a bunch... I got a lot out of it!
"Stefi" wrote:
If number to be searched is in A1, then put in C1
=COUNTIF(Sheet2!B:B;A1)
Regards,
Stefi
€˛PaulGrowns1€¯ ezt Ć*rta:
I have 2 worksheets.
I need to compare a single figure in column A on sheet 1 to the
entire
column B on sheet 2 and count how many times the figure in A
appears in
column B and then place this in Column C on sheet 1.
CAn somebody please help me with the formula???????????
--
Piranha
------------------------------------------------------------------------
Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=20435
View this thread:
http://www.excelforum.com/showthread...hreadid=471717