mistahmistah
New Member
- Joined
- May 8, 2014
- Messages
- 21
Hello,
I am using a table that contains these three columns. I want to be able to identify them as individual records (1,2,3...). Separate line items could have the same value for two columns, but one of these three columns values will be different (bottom row of example). I am going to be importing new data every day and would like to continue to ensure I am not creating new records when the records have not changed. Can this be done via Excel?
My mind went to two seperate spreadsheets using an Index and Match, but ran into formula issues since one spreadsheet will have the record id, and the other needs to be matched to using the below data to know if there is a pre existing record id or not. Please help!
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I am using a table that contains these three columns. I want to be able to identify them as individual records (1,2,3...). Separate line items could have the same value for two columns, but one of these three columns values will be different (bottom row of example). I am going to be importing new data every day and would like to continue to ensure I am not creating new records when the records have not changed. Can this be done via Excel?
My mind went to two seperate spreadsheets using an Index and Match, but ran into formula issues since one spreadsheet will have the record id, and the other needs to be matched to using the below data to know if there is a pre existing record id or not. Please help!
| MEI_ID | OrderID | OrderItemID |
| 583958 | 808007 | 831158 |
| 67939 | ||
| 79641 | ||
| 397990 | ||
| 398821 | 69950 | 48624 |
| 569300 | 713482 | 765420 |
| 569300 | 713482 | 765421 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
