Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Microsoft Word 2000 Tables
I am trying to find a way of counting the number of non-blank cells in a word
table column. The table formula =COUNT(ABOVE) returns the total number of cells regardless of what they contain. If there is a way of excluding the cell on the table heading row then this would be better still. Can anyone help? Regards, Neo. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Microsoft Word 2000 Tables
Hi Neo,
AFAIK, there's no reliable way of counting the number of rows in a table using a formula field, let along the number of non-blank rows. The 'ABOVE' and similar expressions need to be handled with particular caution. See my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 for a detailed explanation. If you really need a count, you'll have to do it manually, or code a macro to do it for you. Cheers -- macropod [MVP - Microsoft Word] "Neo" wrote in message ... I am trying to find a way of counting the number of non-blank cells in a word table column. The table formula =COUNT(ABOVE) returns the total number of cells regardless of what they contain. If there is a way of excluding the cell on the table heading row then this would be better still. Can anyone help? Regards, Neo. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
Word & WordPerfect | Microsoft Word Help | |||
Is there something like wordperfect "variables" in microsoft word? | Microsoft Word Help | |||
WP merge file to Word | Tables | |||
In Word, how can I see all files (*.*) in "save as"? | New Users |