Conditional Cells Filing
Solved/Closed
Branok
Posts
7
Registration date
Friday September 11, 2015
Status
Member
Last seen
October 9, 2015
-
Sep 11, 2015 at 08:00 AM
Branok Posts 7 Registration date Friday September 11, 2015 Status Member Last seen October 9, 2015 - Sep 11, 2015 at 09:54 AM
Branok Posts 7 Registration date Friday September 11, 2015 Status Member Last seen October 9, 2015 - Sep 11, 2015 at 09:54 AM
Related:
- Conditional Cells Filing
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel arrow keys not moving cells - Guide
- Conditional format based on another cell containing text - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 11, 2015 at 09:18 AM
Sep 11, 2015 at 09:18 AM
Branok, Good morning.
Try to use:
A1 --> =IF(ISNUMBER(MATCH("Failure",C1:C20,0)),B1,"")
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
A1 --> =IF(ISNUMBER(MATCH("Failure",C1:C20,0)),B1,"")
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Branok
Posts
7
Registration date
Friday September 11, 2015
Status
Member
Last seen
October 9, 2015
Sep 11, 2015 at 09:54 AM
Sep 11, 2015 at 09:54 AM
Hallo Mazzaropi,
Thank you for your advice,
but unfortunately it doesn't work for some reason,
it show an error...
What i need in brief, is to Fill CELL A1 with text from CELL B1(in this cell is text describing an procedure required) if any (one or more) of CELLS in COLUMN C contains world "Failure".
I am getting hopeless :)
Thank you for your advice,
but unfortunately it doesn't work for some reason,
it show an error...
What i need in brief, is to Fill CELL A1 with text from CELL B1(in this cell is text describing an procedure required) if any (one or more) of CELLS in COLUMN C contains world "Failure".
I am getting hopeless :)