Aug 25 2021 04:25 PM
Here is an example of a cell. I essentially want to sort a data file of over 2000 entries by just the BCL-6 entries using the H Score values (in bold). So all entries above and below a cutoff of H score 1.4. Note that because H score is also used with another stain, I have to specify which H score. Is there a formula I can write to help me with this? The example shown is one cell is a database with 8 columns. Thanks for any help!
BETA INTEGRIN STAIN: H SCORE: 1.8 POSITIVE/ NORMAL RESULT. BCL-6 STAIN: H SCORE: 3.8 POSITIVE/ ABNORMAL RESULT. INTERPRETATION: THE BETA-3 INTEGRIN EXPRESSION IS NORMAL AND THE ENDOMETRIUM IS "IN-PHASE" BUT BCL-6 EXPRESSION IS ABNORMAL SUGGESTING THE PRESENCE OF ENDOMETRIOSIS OR HYDROSALPINGES. · |
Aug 25 2021 10:56 PM
@Angress Perhaps something like in the attached file. Not very elegant but it could work if the wording and spacing of "BCL-6 STAIN: H SCORE: " is always the same.
Have added a few records and juggled the text around a bit to test the formula. Seems to work. See attached.
Aug 26 2021 07:26 AM
Riny,
THank you so much. I tried applying your formula in the test file but I am getting a value error (see attached). I did not change anything. Just took a new data field and tried applying. Could it be a formatting error on my part?
Dan
Aug 26 2021 07:50 AM - edited Aug 26 2021 07:51 AM
@Angress As mentioned, the wording and spacing has to be exactly the same for all occurrences of "BCL-6 STAIN: H SCORE: " . In my example, the string to look for should be exactly like that, i.e. 22 characters long.
In the two examples you added the first one has an extra space between the ":" and the "H"
"BCL-6 STAIN: H SCORE: "
And in the second example you have two space like above and a hyphen between "H" and "score"
"BCL-6 STAIN: H-SCORE: "
If there is no way to make this consistent, it's going to be difficult to make it work. But perhaps you can adapt the formula to you real world scenario and make sure that the data is consistent.