Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database look up
I have a sheet of data that may look somethihng like this: A B C 1 1 2 2 1 3 1 3 1 I want to set up a program that I can tell to look in the sheet and no only count the number of 1's, but count it my column. For exmaple if look up 1's I want the result to look like: A = 2 B = 2 C= 1 or something like this where is gives me a tally of matches in column. Any ideas -- kola556 ----------------------------------------------------------------------- kola5567's Profile: http://www.excelforum.com/member.php...fo&userid=2461 View this thread: http://www.excelforum.com/showthread.php?threadid=39942 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database look up
=countif(A:A,1)
=countif(B:B,1) =countif(C:C,1) -- Regards, Tom Ogilvy "kola5567" wrote in message ... I have a sheet of data that may look somethihng like this: A B C 1 1 2 2 1 3 1 3 1 I want to set up a program that I can tell to look in the sheet and not only count the number of 1's, but count it my column. For exmaple if I look up 1's I want the result to look like: A = 2 B = 2 C= 1 or something like this where is gives me a tally of matches in a column. Any ideas? -- kola5567 ------------------------------------------------------------------------ kola5567's Profile: http://www.excelforum.com/member.php...o&userid=24614 View this thread: http://www.excelforum.com/showthread...hreadid=399428 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Transforming messy database into clean database | Excel Discussion (Misc queries) |