Hello guys :),
I use Excel 12.
What I need help with is a conditional filling of cells, based on values in different cells/in the certain row.
I ll try describe what I need on example.
Legend: CELL A - Cell i need fill with information from cell B
CELL B- Cell always containing "text" which (conditionally) I'd like to have in Cell A
CELL C (It would be better if applicable on whole row) - The Cell, which might contain different VALUES (Success, Failure, N/A)
Example: I need CELL A to be filled by text from CELL B, under condition that there is a specific value in CELL C (VALUE i am interested in: Failure).
Even better would be having CELL A filled with text from CELL B when desired condition appears in any cell in row or column.