Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You could then concatenate the fields in your table box together is one way I could think:
=Count(Distinct col1 & '|' & col2 & '|' & col3) ...etc
Do you have a unique key in your table data? If so, this should be something like:
=count(Distinct UniqueColumnName)
As of right now, no - no Unique ID.
You could then concatenate the fields in your table box together is one way I could think:
=Count(Distinct col1 & '|' & col2 & '|' & col3) ...etc
That seems to have worked! Thanks!