Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HEEEELPPPP!!!!!!
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??????????? |
#2
|
|||
|
|||
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??????????? |
#3
|
|||
|
|||
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??????????? |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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" 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??????????? |
#6
|
|||
|
|||
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" wrote: 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" 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??????????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|