| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Retrieve specific date from one row of one column that is changing
Can anybody help me with this? Or do you need further clarification?
"lpdc" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Retrieve specific date from one row of one column that is changing
I inserted a new column A.
With your test data, the data went to row 20. On the lastrow (I'm gonna use 20, so it's Cell A20), put this formula: =b20 Then in one row up (A19), put this formula: =IF(LEN(B19)=6,B19,A20) And drag it up to the top of the column. It looked like this when I was done: 598006 51000004 CONSUMPTION-MAINTENANCE PARTS 598006 71000000 MAINTENANCE 598006 71000047 MAINTENANCE SERVICES 598006 71080002 DEPRECIATION - PLANTS 598006 71190070 I/C - PRINT SHOP CHARGES 598006 598006 TNY - NB LINE #2 598007 51000004 CONSUMPTION-MAINTENANCE PARTS 598007 71000000 MAINTENANCE 598007 71000047 MAINTENANCE SERVICES 598007 71010000 SUPPLIES 598007 71080002 DEPRECIATION - PLANTS 598007 71080004 DEPRECIATION - OFFICE 598007 598007 TNY - NB LINE #3 598008 51000004 CONSUMPTION-MAINTENANCE PARTS 598008 71000000 MAINTENANCE 598008 71000047 MAINTENANCE SERVICES 598008 71040002 MACHINE RENT 598008 71080002 DEPRECIATION - PLANTS 598008 71190040 PRODUCTION COSTS-OVERHEAD 598008 598008 TNY - CHARLIE #6 BAKERY lpdc wrote: 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 -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
