In your data, you've entered the contractor for job 2 on 1/2 as
B(Alt-Enter)A(Alt-Enter)C
When shown in a cell with Wrap Text turned on, the contractors show on
separate lines in the cell
If Wrap Text is off, you see little boxes instead.
If you want these counted separately, you should enter each contractor's
information on a separate row in the data. For example, instead of:
Date Job Contractor
1/2 2 B(Alt-Enter)A(Alt-Enter)C
enter:
Date Job Contractor
1/2 2 B
1/2 2 A
1/2 2 C
HoganD87 wrote:
EXTREMELY IMPORTANT!
My Pivot Table
example.
"SPREADSHEET"
DATE JOB CONTRACTOR
1/1 1 A
1/2 2 B \
A One Cell
C /
1/3 3 C
when I graph how many time each contractor is used its...
"MY UNWANTED GRAPH"
contractor A.... 1 time
contractor B [] A [] C... 1 time
contractor C... 1 time
How, if at all possible can I make it...
"WHAT I WANT"
contractor A... 2 times
contractor B... 1 time
contractor C... 2 times
And whats with the boxes in
"contractor B [] A [] C... 1 time"
notes:
=SUM(IF(ISNUMBER(H3:H43),1,0)) Thats my formula for my pivot table
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html