| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
uneven ranges and coding
I have a lengthy file of absence data and I am trying to calculate the lenght
of absence (ie number of days) but can't seem to figure this out. I can easily figure out the 1 day absences but I can't figure out how to do a formula around the different amount of entries for each person, different coding for each person, etc. A B C EE1 JAN 1/06 SICK1ST EE1 JAN 2/06 SICKCON EE1 JAN 3/06 SICKCON EE1 MAR 1/06 SICK1ST EE2 FEB 12/06 SICK1ST EE2 FEB 27/06 SICK1ST EE3 JUN 12/06 SICK1ST EE3 JUN 13/06 SICKCON EE3 JUN 14/06 SICKCON EE3 JUN 15/06 SICKCON EE3 JUN 16/06 SICKCON EE3 JUN 17/06 SICKCON EE3 SEP 1/06 SICK1ST EE4 MAR 3/06 SICK1ST EE4 MAR 4/06 SICKCON EE4 APR 12/06 SICK1ST - Lori16 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Font looks uneven in spreadsheet | Excel Discussion (Misc queries) | |||
| lookup with uneven columns | Excel Worksheet Functions | |||
| Counting and colour coding ranges of occurances | New Users to Excel | |||
| Sort a list with uneven row information | Excel Worksheet Functions | |||
| An uneven time-increment | Charts and Charting in Excel | |||
Threaded Mode
