| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve specific date from one row of one column that is changing
How do I pull a specific cost center number from column B to line up with an
account also in column B. For example I have a list of accounts followed by the cost center that I need to tie to the account associated with the cost center. The number of accounts and cost centers are changing as I go down through column B. Example: Column A Column B 51000004 CONSUMPTION-MAINTENANCE PARTS 71000000 MAINTENANCE 71000047 MAINTENANCE SERVICES 71080002 DEPRECIATION - PLANTS 71190070 I/C - PRINT SHOP CHARGES 598006 TNY - NB LINE #2 51000004 CONSUMPTION-MAINTENANCE PARTS 71000000 MAINTENANCE 71000047 MAINTENANCE SERVICES 71010000 SUPPLIES 71080002 DEPRECIATION - PLANTS 71080004 DEPRECIATION - OFFICE 598007 TNY - NB LINE #3 51000004 CONSUMPTION-MAINTENANCE PARTS 71000000 MAINTENANCE 71000047 MAINTENANCE SERVICES 71040002 MACHINE RENT 71080002 DEPRECIATION - PLANTS 71190040 PRODUCTION COSTS-OVERHEAD 598008 TNY - CHARLIE #6 BAKERY The cost centers are the six digit numbers I would like to have the cost center in column A next the the account. Clear as mud I know, lpdc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| compare date to column data | Excel Worksheet Functions | |||
| HELP: Comparison IF statement | Excel Worksheet Functions | |||
| Activating "Todays Date" column upon opening? | Excel Discussion (Misc queries) | |||
| Count cells based on date range in another column | New Users to Excel | |||
Threaded Mode
