Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding total # of records in an Excel file without scrolling
I am new to Excel 2003 and would like to know how I can find the total number
of records / rows in a particular file without scrolling down until I see the last row entered. Is there someplace that gives me a total? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding total # of records in an Excel file without scrolling
Goto Last Cell?
LQ wrote: I am new to Excel 2003 and would like to know how I can find the total number of records / rows in a particular file without scrolling down until I see the last row entered. Is there someplace that gives me a total? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding total # of records in an Excel file without scrolling
Hi,
One way, Alt +F11 to open vb editor. Right click 'This workbook' and insert module and paste this in on the right. Call with =lastrow() in a worksheet cell Function lastrow() lastrow = ActiveSheet.UsedRange.Rows.Count End Function Mike "LQ" wrote: I am new to Excel 2003 and would like to know how I can find the total number of records / rows in a particular file without scrolling down until I see the last row entered. Is there someplace that gives me a total? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding total # of records in an Excel file without scrolling
In an empty cell, enter =COUNTA(A:A) where A is the column where you want to
count non-empty cells. Note that some columns may have more entries than others, so it matters on which column you run this function. Also, note that this counts the number of non-blank cells in the column; it does not return the number of the last non-blank row if there are blank cells within the column. Example: Say a1:a10 contains names, b1:b10 values, non of which are blank, b11 is blank, b12 contains =SUM(B1:B10) CountA(A:A) returns 10, CountA(B:B) returns 11, NOT! 12. Another caveat: visially, a zero-length character string looks just like a blank cell, but it *IS* counted by COUNTA. -- TedMi "LQ" wrote: I am new to Excel 2003 and would like to know how I can find the total number of records / rows in a particular file without scrolling down until I see the last row entered. Is there someplace that gives me a total? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding total # of records in an Excel file without scrolling
Instead of scrolling, just type CTRL-down arrow.
"tedmi" wrote: In an empty cell, enter =COUNTA(A:A) where A is the column where you want to count non-empty cells. Note that some columns may have more entries than others, so it matters on which column you run this function. Also, note that this counts the number of non-blank cells in the column; it does not return the number of the last non-blank row if there are blank cells within the column. Example: Say a1:a10 contains names, b1:b10 values, non of which are blank, b11 is blank, b12 contains =SUM(B1:B10) CountA(A:A) returns 10, CountA(B:B) returns 11, NOT! 12. Another caveat: visially, a zero-length character string looks just like a blank cell, but it *IS* counted by COUNTA. -- TedMi "LQ" wrote: I am new to Excel 2003 and would like to know how I can find the total number of records / rows in a particular file without scrolling down until I see the last row entered. Is there someplace that gives me a total? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding total # of records in an Excel file without scrolling
CTRL-End will take you to the cell that Excel thinks is the last used
cell (though this might be beyond the last record). CTRL-Home will take you back to the first cell. Hope this helps. Pete On Nov 5, 9:25*pm, LQ wrote: I am new to Excel 2003 and would like to know how I can find the total number of records / rows in a particular file without scrolling down until I see the last row entered. Is there someplace that gives me a total? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding duplicate records | Excel Worksheet Functions | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
What Excel Formula = finding dup records and removing them? | Excel Worksheet Functions | |||
Finding duplicate records in Excel | Excel Discussion (Misc queries) |