| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
write a function to determine if cells have names
I am doing a roster and would like to know how to do a function to make sure cells certain cells have names present eg. cells a1 : a5 should have names present - is there a function in say a6 that if all cells (a1:a5) have a name present a6 = true, and if any cell has no name present a6 = false (or any other text) I want this to make sure all cells are filled in with a name andrewm -- andrewm ------------------------------------------------------------------------ andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130 View this thread: http://www.excelforum.com/showthread...hreadid=377637 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using SUM function with #N/A in some cells | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Threaded Mode
