Missing Criteria in Table

jabaker54

Registered User.
Local time
Today, 16:33
Joined
Jul 30, 2014
Messages
11
Hello,

I was wondering if there was a special character you entered into the column area if you have missing data.

For example,

I am trying to run some statistical analyses using a pivot chart. I want to make sure that every box in a specific column is filled. For some of rows I am missing numbers for some of there columns. If there is missing data do I put a wild card?:confused:

EXAMPLE:

First Last Middle Average

John Smith Adam 100

Smith John Peter (Blank) <--- no data

(Now if I were to find the average of both it wont run)


Thanks for all the help!

Justin
 
Really? How do you wish to run average on a set containing one value and no value? The Average function disregards the fields with no value and quite right too, isn't it?
 
I was dumb. It works. I just have to make sure the column is labeled "number" for data type.
 

Users who are viewing this thread

Back
Top Bottom