Anybody who used ANY library to process xslx knows MS keeps changing it :-) About ranges… can you give me the range for whole columns minus 6 first records and 9 last records?
Anybody who used ANY library to process xslx knows MS keeps changing it :-)
I highly doubt that, also, people in corporate finance do not use libraries to process excel files.
About ranges… can you give me the range for whole columns minus 6 first records and 9 last records?
=OFFSET(first_cell, 7, COLUMNS(range_name), ROWS(range_name)-9-7) where range_name is the label given to the whole table and first_cell is its first cell.
Anybody who used ANY library to process xslx knows MS keeps changing it :-) About ranges… can you give me the range for whole columns minus 6 first records and 9 last records?
I highly doubt that, also, people in corporate finance do not use libraries to process excel files.
=OFFSET(first_cell, 7, COLUMNS(range_name), ROWS(range_name)-9-7)whererange_nameis the label given to the whole table andfirst_cellis its first cell.Such a weird argument that you’ve responding to, as the answer (as you provided) is so easy and well known.