| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return text not excel address
I need help creating a student test answer report. I want the student's
correct answer returned with a * and their wrong answers returned from the contents of the excel adress not the adress (their wrong answer should be diplayed). Thank you for your time and help. Susan KEY STUDENT I got this far. B B =IF(ISNUMBER(FIND("B",B2)),"*", "B2") C D =IF(ISNUMBER(FIND("C",B3)),"*", "B3") D D =IF(ISNUMBER(FIND("D",B4)),"*", "B4") D D =IF(ISNUMBER(FIND("D",B5)),"*", "B5") B A =IF(ISNUMBER(FIND("B",B6)),"*", "B6") C C =IF(ISNUMBER(FIND("D",B7)),"*", "B7") E A =IF(ISNUMBER(FIND("E",B8)),"*", "B8") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the return from ADDRESS within another formula? | Excel Worksheet Functions | |||
| Return a cell address | Excel Worksheet Functions | |||
| Excel Hyperlinks; return cell address | Excel Discussion (Misc queries) | |||
| Address function to return values from min row | Excel Discussion (Misc queries) | |||
| return cell address of longest text string in a range | Excel Discussion (Misc queries) | |||
Threaded Mode
