Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count a name
c3 = "pass" If a:1 is "Bob Smith" and his name appears in a list of names
B2:b200 .....would appreciate any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count a name
c3 = "pass" If a:1 is "Bob Smith" and his name appears in a list of names B2:b200 .....would appreciate any help. I don't know what you asking how about this =If(A1="Bob Smith","pass","") -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=524008 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count a name
I am trying to assign a passing grade to Bob Smith whose name appears in a
very long list of names in b2:b200 "davesexcel" wrote: c3 = "pass" If a:1 is "Bob Smith" and his name appears in a list of names B2:b200 .....would appreciate any help. I don't know what you asking how about this =If(A1="Bob Smith","pass","") -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=524008 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count a name
bob smith =COUNTIF(B2:B200,E12) This formula will count the number of criteria in range B2:B200 E12 in this formula is the criteria, so you would type bob smith in E12, adjust the formula to meet your needs -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=524008 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count a name
thank you ...works GREAT
"davesexcel" wrote: bob smith =COUNTIF(B2:B200,E12) This formula will count the number of criteria in range B2:B200 E12 in this formula is the criteria, so you would type bob smith in E12, adjust the formula to meet your needs -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=524008 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |