How to search for a range of cells in excel for a particular string and return the value of the cell that does not contain that stringHow to convert a column number (eg. 127) into an excel column (eg. AA)Return empty cell from formula in ExcelShortcut to Apply a Formula to an Entire Column in ExcelVBA return index of a cell containing a particular stringIF a cell contains a stringVBA Excel: How to check if a value is in a selected range of values (or current cell)How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loopsadd cell in Excel for each cell in other column that contains valueSearch a range of strings in a range of cellsExcel: Search for if a cell contains any of the values from a list of possible values and return all that matched (in a cell)
What is the tangent at a sharp point on a curve?
Showing mass murder in a kid's book
How do I lift the insulation blower into the attic?
What's the meaning of "what it means for something to be something"?
Magnifying glass in hyperbolic space
What is this high flying aircraft over Pennsylvania?
Can creatures abilities target that creature itself?
Offset in split text content
Travelling in US for more than 90 days
Make a Bowl of Alphabet Soup
Taking the numerator and the denominator
Why do Radio Buttons not fill the entire outer circle?
Extract substring according to regexp with sed or grep
Why didn't Voldemort know what Grindelwald looked like?
How do you say "Trust your struggle." in French?
Control width of columns in a tabular environment
Calculate Pi using Monte Carlo
What is the period/term used describe Giuseppe Arcimboldo's style of painting?
In the event of Brexit being postponed beyond the EU elections, will UK voters in EU countries be eligible to participate?
How to preserve electronics (computers, ipads, phones) for hundreds of years?
Can a Knock spell open the door to Mordenkainen's Magnificent Mansion?
Are hand made posters acceptable in Academia?
Strange behavior in TikZ draw command
Relations between homogeneous polynomials
How to search for a range of cells in excel for a particular string and return the value of the cell that does not contain that string
How to convert a column number (eg. 127) into an excel column (eg. AA)Return empty cell from formula in ExcelShortcut to Apply a Formula to an Entire Column in ExcelVBA return index of a cell containing a particular stringIF a cell contains a stringVBA Excel: How to check if a value is in a selected range of values (or current cell)How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loopsadd cell in Excel for each cell in other column that contains valueSearch a range of strings in a range of cellsExcel: Search for if a cell contains any of the values from a list of possible values and return all that matched (in a cell)
I have a row containing a series of "FALSE" and one cell containing a country value such as "Australia"
How to go through these cells and return the country name in another column
For eg
A1 B1 C1 D1 E1
False False False False Australia
How to go through A1 through E1 and return the value of the cell not containing "False"
excel
edited Mar 7 at 0:59
Tim Williams
88.5k97087
asked Mar 7 at 0:52
user11162755user11162755
1
add a comment |
I have a row containing a series of "FALSE" and one cell containing a country value such as "Australia"
How to go through these cells and return the country name in another column
For eg
A1 B1 C1 D1 E1
False False False False Australia
How to go through A1 through E1 and return the value of the cell not containing "False"
excel
edited Mar 7 at 0:59
Tim Williams
88.5k97087
asked Mar 7 at 0:52
user11162755user11162755
1
with VBA or a formula?
– Ricardo Diaz
Mar 7 at 1:06
add a comment |
I have a row containing a series of "FALSE" and one cell containing a country value such as "Australia"
How to go through these cells and return the country name in another column
For eg
A1 B1 C1 D1 E1
False False False False Australia
How to go through A1 through E1 and return the value of the cell not containing "False"
excel
edited Mar 7 at 0:59
Tim Williams
88.5k97087
asked Mar 7 at 0:52
user11162755user11162755
1
I have a row containing a series of "FALSE" and one cell containing a country value such as "Australia"
How to go through these cells and return the country name in another column
For eg
A1 B1 C1 D1 E1
False False False False Australia
How to go through A1 through E1 and return the value of the cell not containing "False"
excel
excel
edited Mar 7 at 0:59
Tim Williams
88.5k97087
asked Mar 7 at 0:52
user11162755user11162755
1
edited Mar 7 at 0:59
Tim Williams
88.5k97087
asked Mar 7 at 0:52
user11162755user11162755
1
edited Mar 7 at 0:59
Tim Williams
88.5k97087
edited Mar 7 at 0:59
Tim Williams
88.5k97087
edited Mar 7 at 0:59
Tim Williams
88.5k97087
88.5k97087
asked Mar 7 at 0:52
user11162755user11162755
1
asked Mar 7 at 0:52
user11162755user11162755
1
asked Mar 7 at 0:52
user11162755user11162755
1
1
with VBA or a formula?
– Ricardo Diaz
Mar 7 at 1:06
add a comment |
with VBA or a formula?
– Ricardo Diaz
Mar 7 at 1:06
with VBA or a formula?
– Ricardo Diaz
Mar 7 at 1:06
with VBA or a formula?
– Ricardo Diaz
Mar 7 at 1:06
add a comment |
1 Answer
1
active
oldest
votes
I’m not sure what you want to do with the value and you didn’t state if you’ll will encounter multiple occurrence of a cell that doesn’t contain False. But If you run the macro while the range is selected, this will show a message of for the cell value and the range
Dim cel As Range
For Each cel in Selection
If cel.value <> “False” then MsgBox cel.value & “ in cell “ & cel.Address
Next cel
answered Mar 7 at 1:09
Dude_ScottDude_Scott
53427
There is only one occurence of the cell that does not contain "False" and I want to store the unique value in a different column
– user11162755
Mar 7 at 1:10
@user11162755 what column?
– Dude_Scott
Mar 7 at 1:11
Just another column in this sheet to contain the non False value
– user11162755
Mar 7 at 1:18
FOr instance in this case add that value in F1
– user11162755
Mar 7 at 1:26
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55034439%2fhow-to-search-for-a-range-of-cells-in-excel-for-a-particular-string-and-return-t%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I’m not sure what you want to do with the value and you didn’t state if you’ll will encounter multiple occurrence of a cell that doesn’t contain False. But If you run the macro while the range is selected, this will show a message of for the cell value and the range
Dim cel As Range
For Each cel in Selection
If cel.value <> “False” then MsgBox cel.value & “ in cell “ & cel.Address
Next cel
answered Mar 7 at 1:09
Dude_ScottDude_Scott
53427
There is only one occurence of the cell that does not contain "False" and I want to store the unique value in a different column
– user11162755
Mar 7 at 1:10
@user11162755 what column?
– Dude_Scott
Mar 7 at 1:11
Just another column in this sheet to contain the non False value
– user11162755
Mar 7 at 1:18
FOr instance in this case add that value in F1
– user11162755
Mar 7 at 1:26
add a comment |
I’m not sure what you want to do with the value and you didn’t state if you’ll will encounter multiple occurrence of a cell that doesn’t contain False. But If you run the macro while the range is selected, this will show a message of for the cell value and the range
Dim cel As Range
For Each cel in Selection
If cel.value <> “False” then MsgBox cel.value & “ in cell “ & cel.Address
Next cel
answered Mar 7 at 1:09
Dude_ScottDude_Scott
53427
There is only one occurence of the cell that does not contain "False" and I want to store the unique value in a different column
– user11162755
Mar 7 at 1:10
@user11162755 what column?
– Dude_Scott
Mar 7 at 1:11
Just another column in this sheet to contain the non False value
– user11162755
Mar 7 at 1:18
FOr instance in this case add that value in F1
– user11162755
Mar 7 at 1:26
add a comment |
I’m not sure what you want to do with the value and you didn’t state if you’ll will encounter multiple occurrence of a cell that doesn’t contain False. But If you run the macro while the range is selected, this will show a message of for the cell value and the range
Dim cel As Range
For Each cel in Selection
If cel.value <> “False” then MsgBox cel.value & “ in cell “ & cel.Address
Next cel
answered Mar 7 at 1:09
Dude_ScottDude_Scott
53427
I’m not sure what you want to do with the value and you didn’t state if you’ll will encounter multiple occurrence of a cell that doesn’t contain False. But If you run the macro while the range is selected, this will show a message of for the cell value and the range
Dim cel As Range
For Each cel in Selection
If cel.value <> “False” then MsgBox cel.value & “ in cell “ & cel.Address
Next cel
answered Mar 7 at 1:09
Dude_ScottDude_Scott
53427
answered Mar 7 at 1:09
Dude_ScottDude_Scott
53427
answered Mar 7 at 1:09
Dude_ScottDude_Scott
53427
answered Mar 7 at 1:09
Dude_ScottDude_Scott
53427
53427
There is only one occurence of the cell that does not contain "False" and I want to store the unique value in a different column
– user11162755
Mar 7 at 1:10
@user11162755 what column?
– Dude_Scott
Mar 7 at 1:11
Just another column in this sheet to contain the non False value
– user11162755
Mar 7 at 1:18
FOr instance in this case add that value in F1
– user11162755
Mar 7 at 1:26
add a comment |
There is only one occurence of the cell that does not contain "False" and I want to store the unique value in a different column
– user11162755
Mar 7 at 1:10
@user11162755 what column?
– Dude_Scott
Mar 7 at 1:11
Just another column in this sheet to contain the non False value
– user11162755
Mar 7 at 1:18
FOr instance in this case add that value in F1
– user11162755
Mar 7 at 1:26
There is only one occurence of the cell that does not contain "False" and I want to store the unique value in a different column
– user11162755
Mar 7 at 1:10
There is only one occurence of the cell that does not contain "False" and I want to store the unique value in a different column
– user11162755
Mar 7 at 1:10
@user11162755 what column?
– Dude_Scott
Mar 7 at 1:11
@user11162755 what column?
– Dude_Scott
Mar 7 at 1:11
Just another column in this sheet to contain the non False value
– user11162755
Mar 7 at 1:18
Just another column in this sheet to contain the non False value
– user11162755
Mar 7 at 1:18
FOr instance in this case add that value in F1
– user11162755
Mar 7 at 1:26
FOr instance in this case add that value in F1
– user11162755
Mar 7 at 1:26
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55034439%2fhow-to-search-for-a-range-of-cells-in-excel-for-a-particular-string-and-return-t%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
with VBA or a formula?
– Ricardo Diaz
Mar 7 at 1:06