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
- Based on the cell values in cells b77 - Excel Forum
- Based on the values in cells b77 b88 - Excel Forum
- Excel conditional formatting based on date - Guide
- How would you change all cells containing the word pass to green - Excel Forum
- Excel arrow keys not moving cells ✓ - Excel Forum
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 :)
