How to find a cell where a value is different than something (Excel)
I have an excel file with a column filled with 'o's.
However there must be a row in that colum where a cell is not filled with a 'o' (is empty)
Manually looking for the cell, is fruitless. There are so many that I just can not find it.
How can I make a formula that permits me to:
find the cell (from all the cells ina column) where the value is different than 'o' (is empty)?
microsoft-excel worksheet-function
|
show 2 more comments
I have an excel file with a column filled with 'o's.
However there must be a row in that colum where a cell is not filled with a 'o' (is empty)
Manually looking for the cell, is fruitless. There are so many that I just can not find it.
How can I make a formula that permits me to:
find the cell (from all the cells ina column) where the value is different than 'o' (is empty)?
microsoft-excel worksheet-function
Kansai ,, if I suggest Conditional formatting which highlight all empty Cells in the Column, will this works for you ?
– Rajesh S
Feb 4 at 6:07
1
Well, yeah I can try :) Conditional formatting you say.. I ll look into that
– KansaiRobot
Feb 4 at 6:09
1
Wow, there must be something really wrong with this excel sheet. I tried conditional formatting and could not find the empty space :(
– KansaiRobot
Feb 4 at 6:19
1
Thanks. I ll try it when I am back at the office :)
– KansaiRobot
Feb 4 at 6:54
1
Do you need a formula? An alternative is to simply use a Filter, and you can either filter out the empty spaces, or filter out theo
cells.
– BruceWayne
Feb 4 at 16:19
|
show 2 more comments
I have an excel file with a column filled with 'o's.
However there must be a row in that colum where a cell is not filled with a 'o' (is empty)
Manually looking for the cell, is fruitless. There are so many that I just can not find it.
How can I make a formula that permits me to:
find the cell (from all the cells ina column) where the value is different than 'o' (is empty)?
microsoft-excel worksheet-function
I have an excel file with a column filled with 'o's.
However there must be a row in that colum where a cell is not filled with a 'o' (is empty)
Manually looking for the cell, is fruitless. There are so many that I just can not find it.
How can I make a formula that permits me to:
find the cell (from all the cells ina column) where the value is different than 'o' (is empty)?
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked Feb 4 at 6:00
KansaiRobotKansaiRobot
14919
14919
Kansai ,, if I suggest Conditional formatting which highlight all empty Cells in the Column, will this works for you ?
– Rajesh S
Feb 4 at 6:07
1
Well, yeah I can try :) Conditional formatting you say.. I ll look into that
– KansaiRobot
Feb 4 at 6:09
1
Wow, there must be something really wrong with this excel sheet. I tried conditional formatting and could not find the empty space :(
– KansaiRobot
Feb 4 at 6:19
1
Thanks. I ll try it when I am back at the office :)
– KansaiRobot
Feb 4 at 6:54
1
Do you need a formula? An alternative is to simply use a Filter, and you can either filter out the empty spaces, or filter out theo
cells.
– BruceWayne
Feb 4 at 16:19
|
show 2 more comments
Kansai ,, if I suggest Conditional formatting which highlight all empty Cells in the Column, will this works for you ?
– Rajesh S
Feb 4 at 6:07
1
Well, yeah I can try :) Conditional formatting you say.. I ll look into that
– KansaiRobot
Feb 4 at 6:09
1
Wow, there must be something really wrong with this excel sheet. I tried conditional formatting and could not find the empty space :(
– KansaiRobot
Feb 4 at 6:19
1
Thanks. I ll try it when I am back at the office :)
– KansaiRobot
Feb 4 at 6:54
1
Do you need a formula? An alternative is to simply use a Filter, and you can either filter out the empty spaces, or filter out theo
cells.
– BruceWayne
Feb 4 at 16:19
Kansai ,, if I suggest Conditional formatting which highlight all empty Cells in the Column, will this works for you ?
– Rajesh S
Feb 4 at 6:07
Kansai ,, if I suggest Conditional formatting which highlight all empty Cells in the Column, will this works for you ?
– Rajesh S
Feb 4 at 6:07
1
1
Well, yeah I can try :) Conditional formatting you say.. I ll look into that
– KansaiRobot
Feb 4 at 6:09
Well, yeah I can try :) Conditional formatting you say.. I ll look into that
– KansaiRobot
Feb 4 at 6:09
1
1
Wow, there must be something really wrong with this excel sheet. I tried conditional formatting and could not find the empty space :(
– KansaiRobot
Feb 4 at 6:19
Wow, there must be something really wrong with this excel sheet. I tried conditional formatting and could not find the empty space :(
– KansaiRobot
Feb 4 at 6:19
1
1
Thanks. I ll try it when I am back at the office :)
– KansaiRobot
Feb 4 at 6:54
Thanks. I ll try it when I am back at the office :)
– KansaiRobot
Feb 4 at 6:54
1
1
Do you need a formula? An alternative is to simply use a Filter, and you can either filter out the empty spaces, or filter out the
o
cells.– BruceWayne
Feb 4 at 16:19
Do you need a formula? An alternative is to simply use a Filter, and you can either filter out the empty spaces, or filter out the
o
cells.– BruceWayne
Feb 4 at 16:19
|
show 2 more comments
2 Answers
2
active
oldest
votes
How it works:
- Select the required data Range or Entire Column.
- From Home TAB select
Conditional Formatting
. - Click,
New Rule
then fromSelect Rule Type
. - Click,
Use Formula which Cells to format
. - Below you find
Edit the Rule description
. - Write this Formula in Text Box
=ISBLANK($A1)
. - Hit
Format Button
& apply an appropriate
Format and finish withOk
.
As soon you finish with all I've shown Excel will highlight blank Cells.
add a comment |
Click on the header of that column containing 'o's, click Menu - Data - Filter.
Now, click on downarrow icon that appears at the end of header name.
it will open a list of all values in that field.
Untick select All
Tick on Text filters, select Does Not equal, in the next window, enter o
This will hide all values that are o, and shall show only those value that are Empty or are anything other than o.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1401736%2fhow-to-find-a-cell-where-a-value-is-different-than-something-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
How it works:
- Select the required data Range or Entire Column.
- From Home TAB select
Conditional Formatting
. - Click,
New Rule
then fromSelect Rule Type
. - Click,
Use Formula which Cells to format
. - Below you find
Edit the Rule description
. - Write this Formula in Text Box
=ISBLANK($A1)
. - Hit
Format Button
& apply an appropriate
Format and finish withOk
.
As soon you finish with all I've shown Excel will highlight blank Cells.
add a comment |
How it works:
- Select the required data Range or Entire Column.
- From Home TAB select
Conditional Formatting
. - Click,
New Rule
then fromSelect Rule Type
. - Click,
Use Formula which Cells to format
. - Below you find
Edit the Rule description
. - Write this Formula in Text Box
=ISBLANK($A1)
. - Hit
Format Button
& apply an appropriate
Format and finish withOk
.
As soon you finish with all I've shown Excel will highlight blank Cells.
add a comment |
How it works:
- Select the required data Range or Entire Column.
- From Home TAB select
Conditional Formatting
. - Click,
New Rule
then fromSelect Rule Type
. - Click,
Use Formula which Cells to format
. - Below you find
Edit the Rule description
. - Write this Formula in Text Box
=ISBLANK($A1)
. - Hit
Format Button
& apply an appropriate
Format and finish withOk
.
As soon you finish with all I've shown Excel will highlight blank Cells.
How it works:
- Select the required data Range or Entire Column.
- From Home TAB select
Conditional Formatting
. - Click,
New Rule
then fromSelect Rule Type
. - Click,
Use Formula which Cells to format
. - Below you find
Edit the Rule description
. - Write this Formula in Text Box
=ISBLANK($A1)
. - Hit
Format Button
& apply an appropriate
Format and finish withOk
.
As soon you finish with all I've shown Excel will highlight blank Cells.
answered Feb 4 at 6:27
Rajesh SRajesh S
4,0341524
4,0341524
add a comment |
add a comment |
Click on the header of that column containing 'o's, click Menu - Data - Filter.
Now, click on downarrow icon that appears at the end of header name.
it will open a list of all values in that field.
Untick select All
Tick on Text filters, select Does Not equal, in the next window, enter o
This will hide all values that are o, and shall show only those value that are Empty or are anything other than o.
add a comment |
Click on the header of that column containing 'o's, click Menu - Data - Filter.
Now, click on downarrow icon that appears at the end of header name.
it will open a list of all values in that field.
Untick select All
Tick on Text filters, select Does Not equal, in the next window, enter o
This will hide all values that are o, and shall show only those value that are Empty or are anything other than o.
add a comment |
Click on the header of that column containing 'o's, click Menu - Data - Filter.
Now, click on downarrow icon that appears at the end of header name.
it will open a list of all values in that field.
Untick select All
Tick on Text filters, select Does Not equal, in the next window, enter o
This will hide all values that are o, and shall show only those value that are Empty or are anything other than o.
Click on the header of that column containing 'o's, click Menu - Data - Filter.
Now, click on downarrow icon that appears at the end of header name.
it will open a list of all values in that field.
Untick select All
Tick on Text filters, select Does Not equal, in the next window, enter o
This will hide all values that are o, and shall show only those value that are Empty or are anything other than o.
answered Feb 6 at 16:43
VSRawatVSRawat
15512
15512
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1401736%2fhow-to-find-a-cell-where-a-value-is-different-than-something-excel%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
Kansai ,, if I suggest Conditional formatting which highlight all empty Cells in the Column, will this works for you ?
– Rajesh S
Feb 4 at 6:07
1
Well, yeah I can try :) Conditional formatting you say.. I ll look into that
– KansaiRobot
Feb 4 at 6:09
1
Wow, there must be something really wrong with this excel sheet. I tried conditional formatting and could not find the empty space :(
– KansaiRobot
Feb 4 at 6:19
1
Thanks. I ll try it when I am back at the office :)
– KansaiRobot
Feb 4 at 6:54
1
Do you need a formula? An alternative is to simply use a Filter, and you can either filter out the empty spaces, or filter out the
o
cells.– BruceWayne
Feb 4 at 16:19