Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Omit Date from Blank Cell
HI:
I would apprecite help with the following: On WorksheetA, I have a range A1:B10 A1 to A10 contains names of people B1 to B10 contain AM or PM or blank (ie. those who are working AM or PM shift or those who have off) Based on the above I wanted to create another range on WorksheetB which lists Name of all people working AM shift in range A1 to A10 (while leaving out the name of all people who are not working either AM or PM shift ) & list names of all people working PM shift in range B1 to B10 (while leaving out the name of all people who are not working either AM or PM shift ) TIA Vinay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to omit blank cells when calculating weighted averages | Excel Worksheet Functions | |||
OMIT BLANK LINES WHEN FORCING A CARRIAGE RETURN --- PLEASE HELP! | Excel Worksheet Functions | |||
How do I omit a blank cell from a calculation?? | Excel Worksheet Functions | |||
Omit blank cells from function results | Excel Worksheet Functions | |||
Macro to omit blank cells needed | Excel Worksheet Functions |