| 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? |
| 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 | |||
![Richard[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
