Jump to content

Worksheets and Lists of Line Lengths in a Class


ensta

Recommended Posts

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,
 

Link to comment

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.

 

  • Like 1
Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...