Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I hv a table , and i like to display number of row on Top left conner.
Paul
Hi Paul,
I thought that the solution would be easier. But your's is a bit complex. I got it using a macro and variable. See attached solution.
Sub CountRow
set chart = ActiveDocument.GetSheetObject("CH230816")
set v = ActiveDocument.Variables("RowsNum")
v.SetContent chart.GetNoOfRows,trueEnd Sub
Cheers.
Hi Paul,
PFA
-- Rajendra
='Total Number of Row = ' & count(PART_NO_)
Paul,
Did you try expression in Window Title yet?
='Total Number of Row =' & Count(PART_NO_)
Rgds,
Sokkorn
PFA
Update: Count( Distinct PART_NO_)
Hi Paul,
Please find attachment and see the answer where you want.
Garry
Hi All
Thank you for the reply. but my PART_NO_ some have missing value , may i know how to count those with missing value ?
Paul
are you asking abount missing means NULL values??
Hi Paul,
Request you to add one list box of PART_NO_ which shows you that there is no missing value. That missing values comes from your expression.
Garry
SEe the image above. notice the row count and part number count are diff.