Counting User Defined Cells

[rex]

How do you count user defined cells containing strings (ex: 1234 Smith Dr)?
I'm tryin to use the IF function but its doesn't work. If the cell is empty
it will return a value of 0 and if its filled the cell is equal to 1 so it
can be counted.

Are there ways how to do this? I;m just filli up the cells manually thru
data shapes entry. Thanks in advance!

 

[Chris Roth [Visio MVP]]

Hi Rex,

This is one that is obvious, so you're not alone with this problem!

You need to use a function to compare strings, you can't just do it
straightforward, like If("Bob" = "Steve", t , f )

Here's an example:

User.A = "Bob"
User.B = "Steve"
User.Test = If( StrSame(User.A, User.B), true, false )

Or just: If( StrSame("Bob", "Steve"), true, false )

If you want to look at the shape's text, use: ShapeText( TheText )

If you want to look at another shape's text, use ShapeText(
Sheet.5!TheText), where 5 is the ID of the other shape.


--
Hope this helps,

Chris Roth
Visio MVP


Visio Guy: Smart Graphics for Visual People
http://www.visguy.com

 

[Scott]

If you don't care what the value of the cell is, just whether there is
something in the cell, use the LEN() function:

If(LEN(User.A)>0, <data present action>, <no data action>)