| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help on which function to use please !!
Hi to all the much-smarter-people than me out there!!
I've got a spreadsheet that I want to automatically insert names into a sheet based on different shifts they work. It looks like this # Name Surname Monday Tuesday 3 Mary Zwane DAY 4 Dean Daffue NIGHT 5 Given Mkhize DOUBLE etc I need a formula that will autmatically put their names into another worksheet based on the words DAY, NIGHT or DOUBLE. If they put in the word DOUBLE, their name needs to appear in DAY & NIGHT e.g. Monday Tuesday (DAY) Mary Given (NIGHT) Dean Given I've tried different formulas, but because there are more than one result, all the funtions return either FALSE or VALUE#. Can someone please help ??? -- Thanks ! Zee :-) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
