Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

When I sort from a list all of my records are not showing ...
Sent to Computer Experts November 08 01:53 PM

When I sort from a list all of my records are not showing up. I have a total of 1236 records and it only sorts from 752?

 

Optional Information:
OS: Windows 2000; Browser: AOL

Already Tried:
I have tried to sort data from the first column list for a specific category but my excel database will only list from 752 records instead of the total records of 1263. Can I call you directly to get help?

Customer (name blocked for privacy)
Status:  Closed   Value: $9
Info Request
November 8 1:54 PM (1 minute and 24 seconds later)
         
REPLIED to Info RequestCheck Mark

Hi,

Which program are you using?

 



...If you found my answer helpful please click the ACCEPT button.
   Positive Feedback is greatly appreciated.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2028 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Reply
November 8 2:03 PM (8 minutes and 27 seconds later)
         
Reply to John D's Post: I'm using Excel 2000 in Windows.
Customer (name blocked for privacy)
Reply
November 8 2:05 PM (2 minutes and 40 seconds later)
         
Are you still there?
Customer (name blocked for privacy)
Answer
November 8 2:11 PM (5 minutes and 8 seconds later)
         
ACCEPTEDCheck Mark

The reason for this to happen is either you are not selecting the complete range before sorting, or there are formulas in some cells that point to rows above or below them. Is this the case?

 



...If you found my answer helpful please click the ACCEPT button.
   Positive Feedback is greatly appreciated.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2028 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Reply
November 8 2:20 PM (9 minutes later)
         
I'm still waiting for my answer. Are you still available?
Customer (name blocked for privacy)
Reply
November 8 2:24 PM (4 minutes and 7 seconds later)
         
Reply to John D's Post:

Greetings,

I don't think this is the case.

How can I select all of the records and then sort the information that I need from one columns list?

I have a total of 1,263 but when I tried to sort one list for example all of my attendees from a past show that has a code for "CCE" it is only bringing up 80 records out of 752. The other records are not showing up from the total records of 1,263.

Makena

 

Customer (name blocked for privacy)
Reply
November 8 2:33 PM (9 minutes and 41 seconds later)
         

Greetings John,

Are you still there?

Customer (name blocked for privacy)
Answer
November 8 2:38 PM (4 minutes and 7 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2028 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Reply
November 8 2:42 PM (4 minutes and 50 seconds later)
         
I will wait then:)
Customer (name blocked for privacy)
Answer
November 8 2:46 PM (3 minutes and 27 seconds later)
         
REPLIEDCheck Mark

Hi Customer (name blocked for privacy),

I gather from your answer to my two questions that you are 1) making a correct selection of all the table before sorting and 2) there are no formulas in the cells. If the answer is yes to both let me know so that we can go to the next step.

 



...If you found my answer helpful please click the ACCEPT button.
   Positive Feedback is greatly appreciated.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2028 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Reply
November 8 3:03 PM (16 minutes and 46 seconds later)
         
Reply to John D's Post:

Greetings,

Now I understand. There is no formulas in the data at that I'm selected.

Are you saying that I should selected the entire column first , next click the sort button and then sort from there.

Customer (name blocked for privacy)
Answer
November 8 3:15 PM (12 minutes and 9 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2028 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Reply
November 8 3:38 PM (22 minutes and 50 seconds later)
         

Thank you so much John!

I can now finish my project.

Thanks a million!

Makena

Customer (name blocked for privacy)
Answer
November 8 3:41 PM (3 minutes and 32 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Picture
John D -- BS Degree in Engineering. -- 99% Positive Feedback on 2028 Computer Accepts
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the Just Answer service comes from those individuals, not from Just Answer!, and that Just Answer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on Just Answer! are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. Just Answer! is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

Just Answer! > Computer and Software Help