Can i exclude first 25 and last 25 rows from a Column, and also seperate the middle rows to a sheet

Manjunath Vijayakumar

I have a Line count of 100 rows in specific sheet, i want only 50 rows from 26 to 75, which intern excludes first 25 and last 25 rows, and also can i seperate the file with the middle 50 rows

Mark Cronk

Hi @Manjunath Vijayakumar ,

Add a helper column [row] to your sheet. Number your rows 1-100 in that column. Or, use autonumber system cumn to do the same. Then create a report for the sheet. Set the report filter to select [Row] with a value between 26 to 75. Add the other columns you want visible in the report.

Work?

Mark

Manjunath Vijayakumar

Thanks mark, this works out for static data, if the data is dynamic and changes from 100 to higher value or 100 to lower where we need only first 25% of the total rows