P0lar
Member
I have a pipe delimited .txt file export from another system which is likely to run close to 1 million rows when in full use, so importing to excel is risky and likely to slow the calculations etc. Each line shows how long a person spent on an activity on a given day, and there are about a dozen possible activities. I only need to know the total time for all activities for a person for a week which would reduce the number of rows in excel considerably. I can code something to compress the list once it's in a sheet but was wondering if there was a way to do this before the data reaches the sheet so that there's not a risk of exceeding the maximum number of sheet rows?