Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctinos,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctinos,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
TESTING A RANGE OF CELLS
Try
=IF(COUNTIF($A$1:$A$6,B1)0,"Tested","Not Tested) -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Richard" <nomailplease.com wrote in message ... 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? |
#3
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctinos,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
TESTING A RANGE OF CELLS
Try this:
=IF(COUNTIF(A$1:A$6,B1),"Tested","Not Tested") Copy down as needed Biff "Richard" <nomailplease.com wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TESTING A RANGE OF CELLS | New Users to Excel | |||
Testing a person's age to be within a range | Excel Worksheet Functions | |||
Testing Spreadsheet Cells while in a Macro | Excel Discussion (Misc queries) | |||
how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
IF function....testing against values in multiple cells | Excel Worksheet Functions |