ensta Posted September 22, 2017 Share Posted September 22, 2017 Hi, Am trying to work out how to set-up worksheets to, in this case, display a list of all the line lengths in a particular class. Have successfully done a total cumulative value. But this other output would be very helpful/time saving. Any input gratefully received. Cheers, Quote Link to comment
michaelk Posted September 22, 2017 Share Posted September 22, 2017 It sounds like you are doing something like putting =LENGTH(C='This Class') in a cell. If you right click on a row header and choose database you can choose the criteria in the next dialog box. Then in that same row, enter =LENGTH in one of the cells to get the length of each line in that class. 1 Quote Link to comment
ensta Posted September 25, 2017 Author Share Posted September 25, 2017 Hi Michael, Thanks for this. Worked a treat. Cheers, Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.