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. |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com