filter result- total row numbers varies
i want to filter the content of a column in a worksheet. when i make a querry by selecting grade rows 4 to 9 ,i get the following- 3 records found out of 7 records.My doubt is that there are three blank rows above the data. one row is there for the label. so total records is 5+4 it should be 9. but excel gives as 7 as the total records. if i select the whole of col D for filter i get the total number as 10 whereas it should be 11 adding the two rows with calculations of average etc. how can i get the exact number of records which contains data in the excel sheet when i make a querry by filter? for example , if i ask for A1 it should give me as three records found out of five records......the file is attached.
Last edited by sumesh56 : November 29th 12 at 04:16 PM
|