Excel Cannot find Data that is within Spreadsheet Unicorn Meta Zoo #1: Why another podcast? ...
What is the least dense liquid under normal conditions?
What's parked in Mil Moscow helicopter plant?
Is it acceptable to use working hours to read general interest books?
What was Apollo 13's "Little Jolt" after MECO?
PIC mathematical operations weird problem
How to keep bees out of canned beverages?
Can you stand up from being prone using Skirmisher outside of your turn?
What is it called when you ride around on your front wheel?
Where did Arya get these scars?
Why isn't everyone flabbergasted about Bran's "gift"?
Additive group of local rings
Could moose/elk survive in the Amazon forest?
Will I lose my paid in full property
Multiple fireplaces in an apartment building?
Is accepting an invalid credit card number a security issue?
Prove the alternating sum of a decreasing sequence converging to 0 is Cauchy.
What is /etc/mtab in Linux?
Co-worker works way more than he should
Retract an already submitted recommendation letter (written for an undergrad student)
Protagonist's race is hidden - should I reveal it?
All ASCII characters with a given bit count
Rolling Stones Sway guitar solo chord function
How would this chord from "Rocket Man" be analyzed?
A Paper Record is What I Hamper
Excel Cannot find Data that is within Spreadsheet
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar ManaraSelect elements in an array that satisfy a criteriaExcel - find multiple pieces of data in several different columns at onceHow to format stacked bar chart correctlyExcel Conditional Formatting disappears unless smaller dataset in filterHierarchical or recursive counting in excel (preferably within a pivot table)?Removing Duplicates From 1 Column Assocatied with a Name in Multiple RowsDynamic Horizontal Axis Crossing Excel Bubble ChartRefreshing a filter in a table every time slicers updateExcel pivot table treating money as a string when filteringExcel: non-nested data column in Pivot Tables
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I'm running into a very unique issue that I have never had before. I'm unsure what is causing it (or how to reproduce it to share here). I've found multiple examples of this happening within my data and I'm sure there are plenty more than what I've found, but I will speak about one specific instance below.
I have a data set that includes a list of email addresses. I know an email, janedoe@aol.com, appears in my dataset three times. But, when I go to my email column and scroll through the filter, her email does not appear. When I type in the search bar (within the filter), it tells me no cases exist.
But, when I use CTRL+F, the document can find her email address all three times. So I know it is there.
But...this problem is actually impacting my data. When I create pivot tables, people are being left out of the counts. And it's the people who arent being 'found' by Excel. (But they can all be found using CTRL+F).
Has anyone ever run into anything like this or have any troubleshooting tips?
microsoft-excel
asked 16 hours ago
SamanthaSamantha
1
New contributor
Samantha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'm running into a very unique issue that I have never had before. I'm unsure what is causing it (or how to reproduce it to share here). I've found multiple examples of this happening within my data and I'm sure there are plenty more than what I've found, but I will speak about one specific instance below.
I have a data set that includes a list of email addresses. I know an email, janedoe@aol.com, appears in my dataset three times. But, when I go to my email column and scroll through the filter, her email does not appear. When I type in the search bar (within the filter), it tells me no cases exist.
But, when I use CTRL+F, the document can find her email address all three times. So I know it is there.
But...this problem is actually impacting my data. When I create pivot tables, people are being left out of the counts. And it's the people who arent being 'found' by Excel. (But they can all be found using CTRL+F).
Has anyone ever run into anything like this or have any troubleshooting tips?
microsoft-excel
asked 16 hours ago
SamanthaSamantha
1
New contributor
Samantha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Is all of your data within the table? Try resizing the table to see where if it contains all your expected data.
– Mark Fitzgerald
16 hours ago
It's not formatted as a table, just raw data in Excel (coming from an SPSS export)
– Samantha
16 hours ago
1
Extra spaces somewhere?
– DavidPostill♦
15 hours ago
How many unique rows of emails do you have in your data? I've seen cases where the autofilter dropdown will display a message that not all items could be displayed but not sure what the trigger for that is.
– Mark Fitzgerald
15 hours ago
add a comment |
I'm running into a very unique issue that I have never had before. I'm unsure what is causing it (or how to reproduce it to share here). I've found multiple examples of this happening within my data and I'm sure there are plenty more than what I've found, but I will speak about one specific instance below.
I have a data set that includes a list of email addresses. I know an email, janedoe@aol.com, appears in my dataset three times. But, when I go to my email column and scroll through the filter, her email does not appear. When I type in the search bar (within the filter), it tells me no cases exist.
But, when I use CTRL+F, the document can find her email address all three times. So I know it is there.
But...this problem is actually impacting my data. When I create pivot tables, people are being left out of the counts. And it's the people who arent being 'found' by Excel. (But they can all be found using CTRL+F).
Has anyone ever run into anything like this or have any troubleshooting tips?
microsoft-excel
asked 16 hours ago
SamanthaSamantha
1
New contributor
Samantha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm running into a very unique issue that I have never had before. I'm unsure what is causing it (or how to reproduce it to share here). I've found multiple examples of this happening within my data and I'm sure there are plenty more than what I've found, but I will speak about one specific instance below.
I have a data set that includes a list of email addresses. I know an email, janedoe@aol.com, appears in my dataset three times. But, when I go to my email column and scroll through the filter, her email does not appear. When I type in the search bar (within the filter), it tells me no cases exist.
But, when I use CTRL+F, the document can find her email address all three times. So I know it is there.
But...this problem is actually impacting my data. When I create pivot tables, people are being left out of the counts. And it's the people who arent being 'found' by Excel. (But they can all be found using CTRL+F).
Has anyone ever run into anything like this or have any troubleshooting tips?
microsoft-excel
microsoft-excel
asked 16 hours ago
SamanthaSamantha
1
New contributor
Samantha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 16 hours ago
SamanthaSamantha
1
New contributor
Samantha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 16 hours ago
SamanthaSamantha
1
New contributor
Samantha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 16 hours ago
SamanthaSamantha
1
asked 16 hours ago
SamanthaSamantha
1
1
New contributor
Samantha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Samantha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Samantha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Is all of your data within the table? Try resizing the table to see where if it contains all your expected data.
– Mark Fitzgerald
16 hours ago
It's not formatted as a table, just raw data in Excel (coming from an SPSS export)
– Samantha
16 hours ago
1
Extra spaces somewhere?
– DavidPostill♦
15 hours ago
How many unique rows of emails do you have in your data? I've seen cases where the autofilter dropdown will display a message that not all items could be displayed but not sure what the trigger for that is.
– Mark Fitzgerald
15 hours ago
add a comment |
Is all of your data within the table? Try resizing the table to see where if it contains all your expected data.
– Mark Fitzgerald
16 hours ago
It's not formatted as a table, just raw data in Excel (coming from an SPSS export)
– Samantha
16 hours ago
1
Extra spaces somewhere?
– DavidPostill♦
15 hours ago
How many unique rows of emails do you have in your data? I've seen cases where the autofilter dropdown will display a message that not all items could be displayed but not sure what the trigger for that is.
– Mark Fitzgerald
15 hours ago
Is all of your data within the table? Try resizing the table to see where if it contains all your expected data.
– Mark Fitzgerald
16 hours ago
Is all of your data within the table? Try resizing the table to see where if it contains all your expected data.
– Mark Fitzgerald
16 hours ago
It's not formatted as a table, just raw data in Excel (coming from an SPSS export)
– Samantha
16 hours ago
It's not formatted as a table, just raw data in Excel (coming from an SPSS export)
– Samantha
16 hours ago
1
1
Extra spaces somewhere?
– DavidPostill♦
15 hours ago
Extra spaces somewhere?
– DavidPostill♦
15 hours ago
How many unique rows of emails do you have in your data? I've seen cases where the autofilter dropdown will display a message that not all items could be displayed but not sure what the trigger for that is.
– Mark Fitzgerald
15 hours ago
How many unique rows of emails do you have in your data? I've seen cases where the autofilter dropdown will display a message that not all items could be displayed but not sure what the trigger for that is.
– Mark Fitzgerald
15 hours ago
add a comment |
0
active
oldest
votes
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
});
}
});
Samantha is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1429079%2fexcel-cannot-find-data-that-is-within-spreadsheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Samantha is a new contributor. Be nice, and check out our Code of Conduct.
Samantha is a new contributor. Be nice, and check out our Code of Conduct.
Samantha is a new contributor. Be nice, and check out our Code of Conduct.
Samantha is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1429079%2fexcel-cannot-find-data-that-is-within-spreadsheet%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
Is all of your data within the table? Try resizing the table to see where if it contains all your expected data.
– Mark Fitzgerald
16 hours ago
It's not formatted as a table, just raw data in Excel (coming from an SPSS export)
– Samantha
16 hours ago
1
Extra spaces somewhere?
– DavidPostill♦
15 hours ago
How many unique rows of emails do you have in your data? I've seen cases where the autofilter dropdown will display a message that not all items could be displayed but not sure what the trigger for that is.
– Mark Fitzgerald
15 hours ago