Hi, I wonder if anyone can help.
In 4 columns I have a range of 4 letters. These letters will only appear if another cell meets certain criteria that I have programmed otherwise the cell will be blank
Column H ="WS"
Column I ="WL"
Column J= "LS"
Column K = "LL"
The range of the cells I want covered is H4:K:29
Within this range I want a formula that returns a "W" in cell if the first letters it sees in the range are "WS" or "WL". If the first thing it sees is "LS" or"LL" it returns an "S" if it sees nothing, then return a 0
I am now at the stage where my brain is exploding!!
In 4 columns I have a range of 4 letters. These letters will only appear if another cell meets certain criteria that I have programmed otherwise the cell will be blank
Column H ="WS"
Column I ="WL"
Column J= "LS"
Column K = "LL"
The range of the cells I want covered is H4:K:29
Within this range I want a formula that returns a "W" in cell if the first letters it sees in the range are "WS" or "WL". If the first thing it sees is "LS" or"LL" it returns an "S" if it sees nothing, then return a 0
I am now at the stage where my brain is exploding!!
