So, if you were to look at this spreadsheet you would see that there are some repeating formations. There are two MaA formations listed for well RA-0001. This is because there were two interpreters for this formation, named 1 and 2. In total in this spreadsheet there are 6 interpreters, 1 through 6. 1 being the best, 6 being the worst.
I need to create a worksheet that only has one interpreter for each formation.
I cant just filter out interpreters 2 through 6 though because interpreter 1 may not have picked every formation. (as you can see in bold, MaC1 was only picked by interpreter 2).
What I need to be able to do is select the best one interpreter for each specific formation for each specific well. (there are about 500 wells or so).
I have organized the data so that it is by well, formation, then interpreter (smallest to largest) aka (best to worst for me).
I was wondering if there was some way I could delete the row of any repeating formation.
Is there an equation I could write? I cant figure it out.
I just want to ensure that I have the best interpreter for each formation, and delete the information of any other interpreter for that formation. simple enough, but i cant figure it out.
Any help would be great! thanks.
<colgroup><col width="124" span="3" style="width:93pt"> </colgroup><tbody>
</tbody>
I need to create a worksheet that only has one interpreter for each formation.
I cant just filter out interpreters 2 through 6 though because interpreter 1 may not have picked every formation. (as you can see in bold, MaC1 was only picked by interpreter 2).
What I need to be able to do is select the best one interpreter for each specific formation for each specific well. (there are about 500 wells or so).
I have organized the data so that it is by well, formation, then interpreter (smallest to largest) aka (best to worst for me).
I was wondering if there was some way I could delete the row of any repeating formation.
Is there an equation I could write? I cant figure it out.
I just want to ensure that I have the best interpreter for each formation, and delete the information of any other interpreter for that formation. simple enough, but i cant figure it out.
Any help would be great! thanks.
WELL NAME | FORMATION | INTERPRETER |
RA-0001 | MaA | 1 |
RA-0001 | MaA | 2 |
RA-0001 | MaA_L | 1 |
RA-0001 | MaA_L | 2 |
RA-0001 | MaA_Mrk1 | 1 |
RA-0001 | MaA_Mrk1 | 2 |
RA-0001 | MaA_Mrk2 | 1 |
RA-0001 | MaA_Mrk2 | 2 |
RA-0001 | MaB | 1 |
RA-0001 | MaB | 2 |
RA-0001 | MaB_Mrk1 | 1 |
RA-0001 | MaB_Mrk1 | 2 |
RA-0001 | MaB_Mrk2 | 1 |
RA-0001 | MaB_Mrk2 | 2 |
RA-0001 | MaB_Mrk3 | 1 |
RA-0001 | MaB_Mrk3 | 2 |
RA-0001 | MaC | 1 |
RA-0001 | MaC | 2 |
RA-0001 | MaC1 | 2 |
RA-0001 | MaC2 | 1 |
RA-0001 | MaC2 | 2 |
RA-0001 | MaC2 | 3 |
RA-0001 | MaC3 | 2 |
RA-0001 | MaC4 | 2 |
RA-0001 | MaD | 1 |
RA-0001 | MaD | 2 |
RA-0001 | MaD_Mrk1 | 1 |
<colgroup><col width="124" span="3" style="width:93pt"> </colgroup><tbody>
</tbody>