mohsin.meo
New Member
- Joined
- Nov 19, 2012
- Messages
- 3
i have a excel list of more than 3008 records having serial nos 1 2 3 and so on at sheet 1.at second sheet i use v lookup formula to extract records by their serial nos b coz i have to print the records in a specific format.
each page of the sheet 1 having 26 records like page 1 having recods of serial no 1 to 26 page 2 having records from serial no 27 to 52.
i have a cell where i write the serial no and i want in the very next cell excell divides the serial no with 26 and show the result which will be the page no of that serial.
for example if i write a serial no with in 26 formula shows 1
if i write a serial no with in 52 formula shows 2
and so on.
please if any one can help i shall be very thankfull.
each page of the sheet 1 having 26 records like page 1 having recods of serial no 1 to 26 page 2 having records from serial no 27 to 52.
i have a cell where i write the serial no and i want in the very next cell excell divides the serial no with 26 and show the result which will be the page no of that serial.
for example if i write a serial no with in 26 formula shows 1
if i write a serial no with in 52 formula shows 2
and so on.
please if any one can help i shall be very thankfull.