Table Box Row Count in Text Box

[#1]

Howdy -

Done some searching already and I can't seem to find a straight answer to this question.  How can I display the number of rows returned within a table box (Object ID: TB04 in my sheet)?  I'd like to put this number in a text box so that in my UI I can show "Number of Rows in your Selection: _________."  Essentially, I'd like exactly the same number that is shown in the status bar.  Thanks!

[joshabbott]

Do you have a unique key in your table data?  If so, this should be something like:

=count(Distinct UniqueColumnName)

[#3]

As of right now, no - no Unique ID.

[joshabbott · Accepted solution]

You could then concatenate the fields in your table box together is one way I could think:

=Count(Distinct col1 & '|' & col2 & '|' & col3) ...etc

[#5]

That seems to have worked!  Thanks!