| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
NON-TEXT VALUES IN CELLS
I'm creating a timesheet for technicians in my service department. I have a
team-based system where technicians split the total hours their team does by the number of techncians on the team, which is 4 per team. It currently takes the hours in a top cell and automatically divides the hours into the individual technicians rows below (e.g., team turns 40 hours in a day, each technician gets 10). Is there any way to exclude a cell if it contains a non-numeric value (e.g., "VACATION" or "SICK"), and recalculate by the number of open cells left? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| Display text depending on values of 3 different cells? | Excel Worksheet Functions | |||
| paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
| Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
Threaded Mode
