• 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


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

first last id seat

galal ghaly

New Member
Excuse me; is it possible to implement the whole attached worksheet? Where I wanted to implement what I had done in the previous letter on the entire worksheet and was implemented only by knowing the beginning and end of the row for each hundred
Find the first seating number and the last seating number of the first 100 students and then the first number of seating and the last number of seats of the next 100 students if the total number of the field exceeds one hundred and more and so using formulas"


Peter Bartholomew

Well-Known Member
Is this the sort of thing you are looking for?


The workbook itself will be of little value to you because I use dynamic arrays to simplify development. I would need to rework to ensure that CSE or implicit intersection replaces DA and that I have removed functions such as SEQUENCE.