I am trying to use the COUNTIF function to display either a "W" (win) or "L" (loss) in three cells across a row (I,J,K).
If column I, J or K match the # in C I would like a W to be displayed in the matching column (I,J,K) and an L in the other two columns, but it is not working out for me.
Bookmarks