• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Complex named ranges

G

GN0001

Member
I have these named ranges


OFFSET(filter!$B$9,(MIN(page,pages)-1)*page_size,,page_size) this is a complex named range and it is called: ndx


And this is another named range called Filter:


IF(ISERROR(ndx),"",IF(ndx=0,"",INDEX(d,ndx,COLUMN())))


And one more it is called pages

INT(records/page_size)+1


Would you please explain about each one? That would be a great help to me.


What does each one do?


Regards,

Guity
 
Page: is the current page


Page_Size: is a constant I believe was 20


Pages: Is the number of pages and is = Integer of ( Number of Records divided by the Page Size)+1

eg: If No Rec=90, Page Size is 20, Pages = int(80/20)+1=5, you need 5 pages of 20 records to show all the records


ndx: is a Range which is offset from Filter!B9 by the Min of the current page or Total pages -1 and it is Page_size in height, ie: It is the position of the current records based on the selcted page


filter: if there is an error in ndx or ndx=0 put "" else get using Index from Range d, ndx rows down and from the current column
 
You must log in or register to reply here.
Back
Top