Jump to content
Sign in to follow this  
sle7en7

Count Strings in Worksheet

Recommended Posts

Hello all,

I was wondering if there was a way to count strings in a worksheet? The values are not in under a database row, they are just punched in stings to cells. I've tried nesting them in "INT" or "Value" functions and using them with "COUNT" or "SUM" functions but to be honest a bit frustrated that I can't even figure out this. What would you suggest?

EDIT: my strings are basically dates in this format; mm/dd/yy

Edited by sle7en7

Share this post


Link to post

If what you want is just to know that a cell has data you can use an extra column with an IF statement.

IF(A2='',0,1)

What this says in English is that if there is nothing in cell A2 then use a value of zero for this cell, otherwise use a value of one for this cell.

You should then be able to use a Count function to get the total you are looking for.

Share this post


Link to post

Ok Pat thanks a lot, good to know the least.

EDIT: I guess we can add "STR2NUM" kind of function to a wishlist but I'm sure it's in needle&mortar somewhere.

Edited by sle7en7

Share this post


Link to post

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.

Sign in to follow this  

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...