Question about Microsoft Excel for PC

1 Answer

Count fields that do not have the words 'TBD'

Posted by Anonymous on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 38 Answers

Try a formula like this:
=COUNTIF(CellRange,"<>TBD")

where CellRange is the area you want to test.

Hope this helps.
Regards,
Scott

Posted on Oct 23, 2013

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How can I count all the pages of more than 16000 documents in a folder. They are *doc and *.docx files.


The number of pages (printed?) would be a function of font size & margins. The number of words would be easier to get a handle on using something like http://ginstrom.com/CountAnything/
or the word counting feature in WORD.
Unfortunately you'd have to open the files to get a count; easy for a few but not so easy for 16,000 files. :(
You could 'count' a sampling of files, then estimate the rest based on file size to word count correlation.

Or you could 'print' the files to PDF & then merge them into a single PDF document. This would give a better printed page count. The could be done on a sampling basis.

Dec 25, 2014 | Microsoft Office Professional 2007 Full...

Tip

HOW TO REMOVE ALL FIELD CODES FROM MS WORD DOCUMENT


The Field Codes always creates issues they are being printed.
To find and see if the field codes are in a document of not, first of all Field Codes needs to be visible.
To make them visible.
Open and MS Word Document.
Go to Tools --> Options
Select 'View' TAB over there.
either in Second or Third column an option would be available with name -
Field Codes - Check mark that option and below there will be an option that will ask 'When'.
There we need to select 'Always'
Hit OK at the bottom. Now all the field codes will be visible in a document if it is available.
To get rid of all the 'Field Codes' At once select the entire text by 'Ctrl+A'
--> 'Ctrl+Shirt+F9' (to remove the field codes at once)
--> 'Ctrl+S' (to save the documnet)

on Aug 08, 2010 | Microsoft Word 2003 for Students &...

Tip

WORD 2003 Shortcuts


All Caps Ctrl+Shift+A
Annotation Alt+Ctrl+M
App Maximize Alt+F10
App Restore Alt+F5
Apply Heading1 Alt+Ctrl+1
Apply Heading2 Alt+Ctrl+2
Apply Heading3 Alt+Ctrl+3
Apply List Bullet Ctrl+Shift+L
Auto Format Alt+Ctrl+K
Auto Text F3
Auto Text Alt+Ctrl+V
Bold Ctrl+B
Bold Ctrl+Shift+B
Bookmark Ctrl+Shift+F5
Browse Next Ctrl+Page Down
Browse Prev Ctrl+Page Up
Browse Sel Alt+Ctrl+Home
Cancel Esc
Center Para Ctrl+E
Change Case Shift+F3
Char Left Left
Char Left Extend Shift+Left
Char Right Right
Char Right Extend Shift+Right
Clear Del
Close or Exit Alt+F4
Close Pane Alt+Shift+C
Column Break Ctrl+Shift+Return
Column Select Ctrl+Shift+F8
Copy Ctrl+C
Copy Ctrl+Insert
Copy Format Ctrl+Shift+C
Copy Text Shift+F2
Create Auto Text Alt+F3
Customize Add Menu Shortcut Alt+Ctrl+=
Customize Keyboard Shortcut Alt+Ctrl+Num +
Customize Remove Menu Shortcut Alt+Ctrl+-
Cut Ctrl+X
Cut Shift+Del
Date Field Alt+Shift+D
Delete Back Word Ctrl+Backspace
Delete Word Ctrl+Del
Distribute Para Ctrl+Shift+J
Do Field Click Alt+Shift+F9
Doc Close Ctrl+W
Doc Close Ctrl+F4
Doc Maximize Ctrl+F10
Doc Move Ctrl+F7
Doc Restore Ctrl+F5
Doc Size Ctrl+F8
Doc Split Alt+Ctrl+S
Double Underline Ctrl+Shift+D
End of Column Alt+Page Down
End of Column Alt+Shift+Page Down
End of Doc Extend Ctrl+Shift+End
End of Document Ctrl+End
End of Line End
End of Line Extend Shift+End
End of Row Alt+End
End of Row Alt+Shift+End
End of Window Alt+Ctrl+Page Down
End of Window Extend Alt+Ctrl+Shift+Page Down
Endnote Now Alt+Ctrl+D
Extend Selection F8
Field Chars Ctrl+F9
Field Codes Alt+F9
Find Ctrl+F
Font Ctrl+D
Font Ctrl+Shift+F
Font Size Select Ctrl+Shift+P
Footnote Now Alt+Ctrl+F
Formatting Properties Shift+F1
Go Back Shift+F5
Go Back Alt+Ctrl+Z
Go To Ctrl+G
Go To F5
Grow Font Ctrl+Shift+.
Grow Font One Point Ctrl+]
Hanging Indent Ctrl+T
Header Footer Link Alt+Shift+R
Help F1
HHC Alt+Ctrl+F7
Hidden Ctrl+Shift+H
Hyperlink Ctrl+K
Indent Ctrl+M
Italic Ctrl+I
Italic Ctrl+Shift+I
Justify Para Ctrl+J
Left Para Ctrl+L
Line Down Down
Line Down Extend Shift+Down
Line Up Up
Line Up Extend Shift+Up
List Num Field Alt+Ctrl+L
Lock Fields Ctrl+3
Lock Fields Ctrl+F11
Macro Alt+F8
Mail Merge Check Alt+Shift+K
Mail Merge Edit Data Source Alt+Shift+E
Mail Merge to Doc Alt+Shift+N
Mail Merge to Printer Alt+Shift+M
Mark Citation Alt+Shift+I
Mark Index Entry Alt+Shift+X
Mark Table of Contents Entry Alt+Shift+O
Menu Mode F10
Merge Field Alt+Shift+F
Microsoft Script Editor Alt+Shift+F11
Microsoft System Info Alt+Ctrl+F1
Move Text F2
New Default Ctrl+N
Next Field F11
Next Field Alt+F1
Next Misspelling Alt+F7
Next Object Alt+Down
Next Window Ctrl+F6
Next Window Alt+F6
Normal Alt+Ctrl+N
Normal Style Ctrl+Shift+N
Normal Style Alt+Shift+Clear (Num 5)
Open Ctrl+O
Open Ctrl+F12
Open Alt+Ctrl+F2
Open or Close Up Para Ctrl+0
Other Pane F6
Other Pane Shift+F6
Outline Alt+Ctrl+O
Outline Collapse Alt+Shift+-
Outline Collapse Alt+Shift+Num -
Outline Demote Alt+Shift+Right
Outline Expand Alt+Shift+=
Outline Expand Alt+Shift+Num +
Outline Move Down Alt+Shift+Down
Outline Move Up Alt+Shift+Up
Outline Promote Alt+Shift+Left
Outline Show First Line Alt+Shift+L
Page Alt+Ctrl+P
Page Break Ctrl+Return
Page Down Page Down
Page Down Extend Shift+Page Down
Page Field Alt+Shift+P
Page Up Page Up
Page Up Extend Shift+Page Up
Para Down Ctrl+Down
Para Down Extend Ctrl+Shift+Down
Para Up Ctrl+Up
Para Up Extend Ctrl+Shift+Up
Paste Ctrl+V
Paste Insert
Paste Format Ctrl+Shift+V
Prev Field Shift+F11
Prev Field Alt+Shift+F1
Prev Object Alt+Up
Prev Window Ctrl+Shift+F6
Prev Window Alt+Shift+F6
Print Ctrl+P
Print Ctrl+Shift+F12
Print Preview Ctrl+F2
Print Preview Alt+Ctrl+I
Proofing F7
Redo Alt+Shift+Backspace
Redo or Repeat Ctrl+Y
Redo or Repeat F4
Redo or Repeat Alt+Return
Repeat Find Shift+F4
Repeat Find Alt+Ctrl+Y
Replace Ctrl+H
Research Lookup Ctrl+Shift+O
Reset Char Ctrl+Space
Reset Char Ctrl+Shift+Z
Reset Para Ctrl+Q
Revision Marks Toggle Ctrl+Shift+E
Right Para Ctrl+R
Save Ctrl+S
Save Shift+F12
Save Alt+Shift+F2
Save As F12
Select All Ctrl+A
Select All Ctrl+Clear (Num 5)
Select All Ctrl+Num 5
Select Table Alt+Clear (Num 5)
Show All Ctrl+Shift+8
Show All Headings Alt+Shift+A
Show Heading1 Alt+Shift+1
Show Heading2 Alt+Shift+2
Show Heading3 Alt+Shift+3
Show Heading4 Alt+Shift+4
Show Heading5 Alt+Shift+5
Show Heading6 Alt+Shift+6
Show Heading7 Alt+Shift+7
Show Heading8 Alt+Shift+8
Show Heading9 Alt+Shift+9
Shrink Font Ctrl+Shift+,
Shrink Font One Point Ctrl+[
Shrink Selection Shift+F8
Small Caps Ctrl+Shift+K
Space Para1 (single spacing) Ctrl+1
Space Para15 (one-and-a-half line spacing) Ctrl+5
Space Para2 (double spacing) Ctrl+2
Spike Ctrl+Shift+F3
Spike Ctrl+F3
Start of Column Alt+Page Up
Start of Column Alt+Shift+Page Up
Start of Doc Extend Ctrl+Shift+Home
Start of Document Ctrl+Home
Start of Line Home
Start of Line Extend Shift+Home
Start of Row Alt+Home
Start of Row Alt+Shift+Home
Start of Window Alt+Ctrl+Page Up
Start of Window Extend Alt+Ctrl+Shift+Page Up
Style Ctrl+Shift+S
Style Separator Alt+Ctrl+Return
Subscript Ctrl+=
Superscript Ctrl+Shift+=
Symbol Font Ctrl+Shift+Q
Task Pane Ctrl+F1
Thesaurus RR Shift+F7
Time Field Alt+Shift+T
Toggle Character Code Alt+X
Toggle Field Display Shift+F9
Toggle Master Subdocs Ctrl+\
Toggle XMLTag View Ctrl+Shift+X
Translate Pane Alt+Shift+F7
Un Hang Ctrl+Shift+T
Un Indent Ctrl+Shift+M
Underline Ctrl+U
Underline Ctrl+Shift+U
Undo Ctrl+Z
Undo Alt+Backspace
Unlink Fields Ctrl+6
Unlink Fields Ctrl+Shift+F9
Unlock Fields Ctrl+4
Unlock Fields Ctrl+Shift+F11
Update Auto Format Alt+Ctrl+U
Update Fields F9
Update Fields Alt+Shift+U
Update Source Ctrl+Shift+F7
VBCode Alt+F11
Web Go Back Alt+Left
Web Go Forward Alt+Right
Word Count List Ctrl+Shift+G
Word Count Recount Ctrl+Shift+R
Word Left Ctrl+Left
Word Left Extend Ctrl+Shift+Left
Word Right Ctrl+Right
Word Right Extend Ctrl+Shift+Right
Word Underline Ctrl+Shift+W

on Dec 03, 2009 | Computers & Internet

1 Answer

Show syllables in words


Perl is a great language for this type of problem.

I recommend using Perl, and installing the Lingua::Phonology::Syllable module. Here is a working example:

use Lingua::Phonology;
use Lingua::Phonology::Syllable;
my $phono = Lingua::Phonology->new();
$phono->features->loadfile;
$phono->symbols->loadfile;
# Create a new Syllable object
my $syll = new Lingua::Phonology::Syllable;
# Create an input word
my @word = $phono->symbols->segment('s','h','e','p','h','e','r','d');
# Allow onset clusters and simple codas
$syll->set_complex_onset;
$syll->set_coda;
# Syllabify the word
$syll->syllabify(@word);
my $count = $syll->count_syll;
print "Count: $count\n"; # prints "Count: 2"
# @word now has features set to indicate a syllabification of
# <shep><herd>

Aug 27, 2014 | Computers & Internet

1 Answer

Word 2007 form fields


you have need for assistance at your home only!!

Jun 01, 2009 | Microsoft Office Word 2007 Full Version...

1 Answer

Count with 2 or more criteria


Can you do this using a pivot table where columns B & C are Row Fields and Count of B&C is data fields.

Jan 17, 2009 | Microsoft Excel for PC

1 Answer

Setting a Formula


You should use the formula COUNT (Cell1, Cell2), please replace Cell1 and Cell2 for the range of your cells in Excell. You could use too the formula COUNT.IF(Cell1,Cell2,Criterion), Cell1 and Cell2 is the range of cells when can exist an entry.
Example The final formula is like:
COUNT(A1:A5)/COUNT.IF(A1:A5,"=x")*100

Nov 24, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer

Calculated field in Excel pivot


Count will only work with numbers. So select another box where you want your number and use this formula: =count(x:x) This should give the count number then you will need to find the difference. In another box, use =sum(x-x). This should give you your difference.


If this helps you, please rate me. Thanks, Patty

Dec 17, 2007 | Computers & Internet

1 Answer

Custum properties


Position the mouse on insertion point where you want to insert the value of the custom property.

Select Field from the Insert menu. Word displays the Field dialog box.

In the list of Categories, choose Document Information.

In the list of Field Names, choose DocProperty.

If you are using Word 97 or Word 2000, click the Options button.

Word displays the Field Options dialog box.

In the Property list, choose the custom property you created (MyProp).
In Word 97 or Word 2000, click on Add to Field.

Select OK to close the Field Options dialog box.

Select OK. Word inserts the value of MyProp in your document.

Is it OK?

Oct 16, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

19 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2854 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18402 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...