TESTING A RANGE OF CELLS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 01 Apr 2007 05:20 GMT

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 to this Message

Peo Sjoblom - 01 Apr 2007 05:34 GMT

Try

=IF(COUNTIF($A$1:$A$6,B1)>0,"Tested","Not Tested)

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

> Column A contains names of students who had taken a test.
> A B C
[quoted text clipped - 17 lines]
>
> Can anyone help?

Reply to this Message

T. Valko - 01 Apr 2007 05:43 GMT

Try this:

=IF(COUNTIF(A$1:A$6,B1),"Tested","Not Tested")

Copy down as needed

Biff

> Column A contains names of students who had taken a test.
> A B C
[quoted text clipped - 17 lines]
>
> Can anyone help?

Reply to this Message

Don Guillett - 01 Apr 2007 14:52 GMT

No formula

Sub checklist()
For Each c In Range("b2:b10")
On Error Resume Next
x = Range("a2:a10").Find(c).Row
If c <> "" And x > 1 Then Cells(x, "c") = "Tested"
Next c
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Column A contains names of students who had taken a test.
> A B C
[quoted text clipped - 17 lines]
>
> Can anyone help?

Reply to this Message