Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of occurences in a list
Hi,
I have a spreadsheet where I'm trying to count the number of occurences of a value against another value (hope that makes sense). See http://spreadsheets.google.com/ccc?k...G1DfgoUtdbx1PA So, for example in B14, I would like to match value B13 against the list in B2 to B11 and return the number of occurences of that value against A14. Can anyone help please? Many thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of occurences in a list
It's not clear what you want to do and your link asks for login credentials.
-- Biff Microsoft Excel MVP "Lucas Reece" wrote in message ... Hi, I have a spreadsheet where I'm trying to count the number of occurences of a value against another value (hope that makes sense). See http://spreadsheets.google.com/ccc?k...G1DfgoUtdbx1PA So, for example in B14, I would like to match value B13 against the list in B2 to B11 and return the number of occurences of that value against A14. Can anyone help please? Many thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of occurences in a list
Sorry. Can you try the link again please. I'm sure I have set it for
everyone to view and edit with login?!?? On 28 May, 18:53, "T. Valko" wrote: It's not clear what you want to do and your link asks for login credentials. -- Biff Microsoft Excel MVP "Lucas Reece" wrote in message ... Hi, I have a spreadsheet where I'm trying to count the number of occurences of a value against another value (hope that makes sense). Seehttp://spreadsheets.google.com/ccc?key=rifcz2bO3G1DfgoUtdbx1PA So, for example in B14, I would like to match value B13 against the list in B2 to B11 and return the number of occurences of that value against A14. Can anyone help please? Many thanks.- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of occurences in a list
Not having a very good night here am I. That meant to say "I'm sure I
have set it for everyone to view and edit without having to login" On 28 May, 19:07, Lucas Reece wrote: Sorry. Can you try the link again please. I'm sure I have set it for everyone to view and edit with login?!?? On 28 May, 18:53, "T. Valko" wrote: It's not clear what you want to do and your link asks for login credentials. -- Biff Microsoft Excel MVP "Lucas Reece" wrote in message ... Hi, I have a spreadsheet where I'm trying to count the number of occurences of a value against another value (hope that makes sense). Seehttp://spreadsheets.google.com/ccc?key=rifcz2bO3G1DfgoUtdbx1PA So, for example in B14, I would like to match value B13 against the list in B2 to B11 and return the number of occurences of that value against A14. Can anyone help please? Many thanks.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of occurences in a list
Still asks for login credentials.
-- Biff Microsoft Excel MVP "Lucas Reece" wrote in message ... Not having a very good night here am I. That meant to say "I'm sure I have set it for everyone to view and edit without having to login" On 28 May, 19:07, Lucas Reece wrote: Sorry. Can you try the link again please. I'm sure I have set it for everyone to view and edit with login?!?? On 28 May, 18:53, "T. Valko" wrote: It's not clear what you want to do and your link asks for login credentials. -- Biff Microsoft Excel MVP "Lucas Reece" wrote in message ... Hi, I have a spreadsheet where I'm trying to count the number of occurences of a value against another value (hope that makes sense). Seehttp://spreadsheets.google.com/ccc?key=rifcz2bO3G1DfgoUtdbx1PA So, for example in B14, I would like to match value B13 against the list in B2 to B11 and return the number of occurences of that value against A14. Can anyone help please? Many thanks.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of occurences in a list
Strange.
How about this? http://spreadsheets.google.com/pub?k...1A&output=html On 28 May, 19:24, "T. Valko" wrote: Still asks for login credentials. -- Biff Microsoft Excel MVP "Lucas Reece" wrote in message ... Not having a very good night here am I. That meant to say "I'm sure I have set it for everyone to view and edit without having to login" On 28 May, 19:07, Lucas Reece wrote: Sorry. Can you try the link again please. I'm sure I have set it for everyone to view and edit with login?!?? On 28 May, 18:53, "T. Valko" wrote: It's not clear what you want to do and your link asks for login credentials. -- Biff Microsoft Excel MVP "Lucas Reece" wrote in message ... Hi, I have a spreadsheet where I'm trying to count the number of occurences of a value against another value (hope that makes sense). Seehttp://spreadsheets.google.com/ccc?key=rifcz2bO3G1DfgoUtdbx1PA So, for example in B14, I would like to match value B13 against the list in B2 to B11 and return the number of occurences of that value against A14. Can anyone help please? Many thanks.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of occurences in a list
It sounds like you just need to use the COUNTIF function. Maybe
=COUNTIF(B2:B11,B13). Ken Norfolk, Va On May 28, 1:41*pm, Lucas Reece wrote: Hi, I have a spreadsheet where I'm trying to count the number of occurences of a value against another value (hope that makes sense). Seehttp://spreadsheets.google.com/ccc?key=rifcz2bO3G1DfgoUtdbx1PA So, for example in B14, I would like to match value B13 against the list in B2 to B11 and return the number of occurences of that value against A14. Can anyone help please? Many thanks. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of occurences in a list
Sorry to sound impatient but can anyone help with this please?
On 28 May, 18:41, Lucas Reece wrote: Hi, I have a spreadsheet where I'm trying to count the number of occurences of a value against another value (hope that makes sense). Seehttp://spreadsheets.google.com/ccc?key=rifcz2bO3G1DfgoUtdbx1PA So, for example in B14, I would like to match value B13 against the list in B2 to B11 and return the number of occurences of that value against A14. Can anyone help please? Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to count the number of occurences of a letter ? | Excel Discussion (Misc queries) | |||
Lookup a value and count the number of associated occurences | Excel Discussion (Misc queries) | |||
count number of occurences on a particular date | Excel Worksheet Functions | |||
List Unique Occurences and Count | Excel Worksheet Functions | |||
How to count number of occurences in an autofilter list | Excel Worksheet Functions |