Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation of records on spreadsheet
Good day,
I am not sure if this is the right forum for this question, but would appreciate any help. I have a spread sheet with a lot of rowws in, about 5000 and before i deleted a lot i had 9000. The question is that when i filter by a certain criteria, i get a message at the very bottom of the spreadsheet saying; "500 of 9540 records found". Can a person change this or is this something that Excel does itself ? Les Stout Les Stout *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation of records on spreadsheet
Hi
this is an Excel build-in feature. -- Regards Frank Kabel Frankfurt, Germany Les Stout wrote: Good day, I am not sure if this is the right forum for this question, but would appreciate any help. I have a spread sheet with a lot of rowws in, about 5000 and before i deleted a lot i had 9000. The question is that when i filter by a certain criteria, i get a message at the very bottom of the spreadsheet saying; "500 of 9540 records found". Can a person change this or is this something that Excel does itself ? Les Stout Les Stout *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation of records on spreadsheet
If your question is "can the status bar reflect the actual number of
records rather than the previous maximum" the answer is yes. The problem is caused when there is text (perhaps a space character) or formatting applied to rows in which the contents were deleted or replaced, but the row itself wasn't deleted. XL still considers those rows used. Select from the row below your last record through a row past the end of your previous data (one way: if you have 5000 records, enter 5001:20000" (without quotes) in the name box at the left of the formula bar). Right-click a selected row headers and choose delete. Depending on your version of XL, you may have to then save and reopen the file, save the file, or do nothing, but when you next filter, the status bar will reflect the right number of records. In article , Les Stout wrote: Good day, I am not sure if this is the right forum for this question, but would appreciate any help. I have a spread sheet with a lot of rowws in, about 5000 and before i deleted a lot i had 9000. The question is that when i filter by a certain criteria, i get a message at the very bottom of the spreadsheet saying; "500 of 9540 records found". Can a person change this or is this something that Excel does itself ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i append records to an excel spreadsheet | Excel Discussion (Misc queries) | |||
Removing records using anther spreadsheet | Excel Discussion (Misc queries) | |||
Retrieve only missing records from two spreadsheet | Excel Discussion (Misc queries) | |||
How can I update a spreadsheet for a new season of records? | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions |