I need help with keeping track of how many components are reported with specific tests.
Here is the logic that I would like to implement with VBA code and insert into my macro. Any help with this would be greatly appreciated.
Thanks,
Lenna
Starting in row 1:
If value in O is either “PRAMO” or “HLAS” and L is not blank
Then
Compare the current row with the row beneath at A, H, N, L and O
If all match,
Return in R (combine value in O & “both”)
Move two rows down and repeat.
If A,H,N,L and O do not match
Return in R (combine value in O & “one”)
Move to the next row
<tbody>
</tbody>
Here is the logic that I would like to implement with VBA code and insert into my macro. Any help with this would be greatly appreciated.
Thanks,
Lenna
Starting in row 1:
If value in O is either “PRAMO” or “HLAS” and L is not blank
Then
Compare the current row with the row beneath at A, H, N, L and O
If all match,
Return in R (combine value in O & “both”)
Move two rows down and repeat.
If A,H,N,L and O do not match
Return in R (combine value in O & “one”)
Move to the next row
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R |
Patient Id | MR Number | Last Name | First Name | Category | Included In Mailing | Log Time | Sample Date | Assigned Date | Test Type | Test Id | ReportDate | Days2SignOff | Order Number | SoftTestCodes | Repeats | Reportable Comments | CombinedCodes |
11 | 1212212 | Smith | Bob | KIDNEY | FALSE | 9/10/2014 | 9/10/2014 | 9/10/2014 | SABI | 604562 | 9/12/2014 | 2 | 211003156 | HLAS | None | | HLASBoth |
11 | 3.3E+07 | Smith | Bob | KIDNEY | FALSE | 9/10/2014 | 9/10/2014 | 9/10/2014 | SABII | 604563 | 9/12/2014 | 2 | 211003156 | HLAS | None | | HLASBoth |
22 | 1.3E+07 | Jones | Jenn | KIDNEY | FALSE | 9/11/2014 | 9/10/2014 | 9/12/2014 | SABI | 604623 | 9/12/2014 | 0 | 211007028 | PRAMO | None | | PRAMOone |
22 | 1.3E+07 | Jones | Jenn | KIDNEY | FALSE | 9/11/2014 | 9/10/2014 | 9/12/2014 | SABII | 604624 | 9/13/2014 | 0 | 211007028 | PRAMO | None | | PRAMOone |
33 | 3.6E+07 | Brian | JASON | KIDNEY | TRUE | 9/10/2014 | 9/8/2014 | 9/12/2014 | SABI | 604495 | 9/12/2014 | 0 | 211004776 | PRAMO | None | | PRAMOboth |
33 | 3.6E+07 | Brian | JASON | KIDNEY | TRUE | 9/10/2014 | 9/8/2014 | 9/12/2014 | SABII | 604496 | 9/12/2014 | 0 | 211004776 | PRAMO | None | | PRAMOboth |
44 | 1E+08 | Ceder | PATRICK | KIDNEY | TRUE | 9/11/2014 | 9/10/2014 | 9/12/2014 | SABI | 604621 | 9/12/2014 | 0 | 211004686 | PRAMO | None | | PRAMOboth |
44 | 1E+08 | Ceder | PATRICK | KIDNEY | TRUE | 9/11/2014 | 9/10/2014 | 9/12/2014 | SABII_RPT | 604622 | 9/12/2014 | 0 | 211004686 | PRAMO | None | | PRAMOboth |
44 | 1E+08 | Ceder | PATRICK | KIDNEY | TRUE | 9/11/2014 | 9/10/2014 | 9/12/2014 | SABI_RPT | 604621 | | 0 | 211004686 | PRAMO | None | | |
44 | 1E+08 | Ceder | PATRICK | KIDNEY | TRUE | 9/11/2014 | 9/10/2014 | 9/12/2014 | SABII | 604622 | | 0 | 211004686 | PRAMO | None | | |
55 | 1E+08 | Spear | ANTHONY | KIDNEY | FALSE | 9/11/2014 | 9/10/2014 | 9/12/2014 | LSM__MICA | 604649 | 9/12/2014 | 0 | 211007470 | HLASM | None | | |
55 | 1E+08 | Spear | ANTHONY | KIDNEY | FALSE | 9/11/2014 | 9/10/2014 | 9/12/2014 | LSMI | 604650 | 9/12/2014 | 0 | 211007470 | HLASM | None | | |
<tbody>
</tbody>