Hello,
Can you assist me with my formula. I am trying to put word "count" in column K if the scenarios below are true.
scenarios are true then formula shows text "count" in column K (FYI i have manually gone down the list and manually put "count" in column L so the formula should show the same results as column L.
column c is manually sorted then sorted by completed at column.
- if column F is blank and column g = Main ICU or ICU brazos then column k = "Count"
for formula below column "number random" need to match to apply formula
- if column f = Main ICU and column g = ICU brazos then column k = "Count"
- if column f = ICU brazos and column g = Main ICU then column k = "Count"
- if column f = Main ICU or ICU brazos and previous matching column C = any of these listed below than column k = "Count"
MAIN ICU, MAIN 6E, ICU BRAZOS, BRAZOS 6, MAIN 5E, MAIN 6W, MAIN 4E, MAIN 4W, BRAZOS 5, MAIN 5W, ED
Please see attached for sample report. Thanks in advance.
Zohaib
Can you assist me with my formula. I am trying to put word "count" in column K if the scenarios below are true.
scenarios are true then formula shows text "count" in column K (FYI i have manually gone down the list and manually put "count" in column L so the formula should show the same results as column L.
column c is manually sorted then sorted by completed at column.
- if column F is blank and column g = Main ICU or ICU brazos then column k = "Count"
for formula below column "number random" need to match to apply formula
- if column f = Main ICU and column g = ICU brazos then column k = "Count"
- if column f = ICU brazos and column g = Main ICU then column k = "Count"
- if column f = Main ICU or ICU brazos and previous matching column C = any of these listed below than column k = "Count"
MAIN ICU, MAIN 6E, ICU BRAZOS, BRAZOS 6, MAIN 5E, MAIN 6W, MAIN 4E, MAIN 4W, BRAZOS 5, MAIN 5W, ED
Please see attached for sample report. Thanks in advance.
Zohaib