| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Labor Costs Budget to Actual
I'm looking for the best way to compare actual labor costs that I have in an
excel file to another excel budget file. In my "Actual" file - there are multiple rows for each employee b/c of labor distribution. I have been using Vlookup to do the comparisons but am wondering if there is a better way. In addition to MTD comparison I would like to do YTD comparisons. My payroll is in SQL database - could data query help??? -- Connie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Labor costs for estimates | Excel Worksheet Functions | |||
| matrix multiplication for labor costs | Excel Worksheet Functions | |||
| Payroll labor costs | Excel Worksheet Functions | |||
| Budget vs. Actual | Excel Discussion (Misc queries) | |||
| YTD Budget Sum if Actual Month has activities | Excel Worksheet Functions | |||
Threaded Mode
