HEEEELPPPP!!!!!!

P

PaulGrowns1

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???????????
 
S

Stefi

If number to be searched is in A1, then put in C1
=COUNTIF(Sheet2!B:B;A1)
Regards,
Stefi

„PaulGrowns1†ezt írta:
 
M

MatthewTap

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!
 
P

Piranha

Hi Matthew,
This may be a typo, but some non-english versions of excel and som
Macintosh versions
of Excel require a semicolon - ; - instead of a comma - , - in som
places, along with
some other variations.
Dave.
MatthewTap said:
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 jus
trying
to help Paul by pointing this out, but there was an innocent typo i
the
COUNTIF from the post. [it could be that it's not a typo and I'm jus
not
entirely sure I know exactly what I'm doing... just trying to lear
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. Th
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
comma
in front of A1, whereas yours had a semi-colon. So, just something t
try
out.


Bottom line though, thanks a bunch... I got a lot out of it!

Stefi said:
If number to be searched is in A1, then put in C1
=COUNTIF(Sheet2!B:B;A1)
Regards,
Stefi

„PaulGrowns1†ezt Ã*rta:
Click to expand...
Click to expand...
 
S

Stefi

Yes, Piranha's guess was right! I use Hungarian version which uses ; as
separator. I used to replace it to , in my messages, but unfortunately I
forgot to do so this time!

Stefi

„MatthewTap†ezt írta:
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 said:
If number to be searched is in A1, then put in C1
=COUNTIF(Sheet2!B:B;A1)
Regards,
Stefi

„PaulGrowns1†ezt írta:
Click to expand...
Click to expand...
 
M

MatthewTap

Dave and Stefi --

Thanks for letting me know... I wasn't aware that there were differences
like that.

I appreciate y'all telling me.

Matt

Stefi said:
Yes, Piranha's guess was right! I use Hungarian version which uses ; as
separator. I used to replace it to , in my messages, but unfortunately I
forgot to do so this time!

Stefi

„MatthewTap†ezt írta:
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 said:
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???????????
Click to expand...
Click to expand...
Click to expand...
 
Top