Thread: TESTING A RANGE OF CELLS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctinos,microsoft.public.excel.worksheetfunctions
Richard[_2_] Richard[_2_] is offline
external usenet poster
  
Posts: 34
Default TESTING A RANGE OF CELLS
Column A contains names of students who had taken a test.
A B C
Tested All Students

Richard Richard tested
Jason Sam not tested
Greg Tom ?
Susan Greg
John Michelle
Michelle John
Jason
Susan

column B will have the names of students who had taken a test and who had
not, beginning with cell C1 I want to search column A for Richard. If
Richard's name is found on column A, then he had taken a test, then C1 will
have a value of "Tested". Otherwise, if Richard is not found in column A,
then C1 will have a valued of "not tested". I used this formula and it did
not work. =IF(A1:A6=B1,"Tested", "Not tested")

Can anyone help?



Reply With QuoteReply With Quote