Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Matching data using date criteria...
I have data entered into 2 separate databases: DB A: roll_num, plate_date (step 1 of process) DB B: roll_num, cut_date, cut_num (step 2 of process) cut_num is unique for every data entry, but the roll_num stays with a roll its entire lifetime, therefore repeating several times in the data tables. What I want to do is link the data sheets together to form one master table. This could done by taking the roll_num and cut_date in DB B and matching it with the closest previous roll_num and plate_date in DB A. My problem is that I have absolutely no idea how to do this. Any suggestions? Sorry if this is unclear...I'll explain better if needed. Thanks, Joe Z -- JoeZ ------------------------------------------------------------------------ JoeZ's Profile: http://www.excelforum.com/member.php...o&userid=22919 View this thread: http://www.excelforum.com/showthread...hreadid=467264 |
#2
|
|||
|
|||
Anyone have any ideas? -- JoeZ ------------------------------------------------------------------------ JoeZ's Profile: http://www.excelforum.com/member.php...o&userid=22919 View this thread: http://www.excelforum.com/showthread...hreadid=467264 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
Problems with DATE data type | New Users to Excel | |||
Matching Date From Two Groups | Excel Worksheet Functions | |||
Sum range of values that meet date criteria | Excel Discussion (Misc queries) | |||
Count data entries and date problem | Excel Worksheet Functions |