Fills Series options sometimes messes the count!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to asking Excel to count up a list of things for me.
I often start at 1 and end at 89.
Yet sometimes is messes up the count. Sometimes even the bar to left count
is also wrong what is happening. How do I make sure that I get a perfect
count every time.

I often press edit- fill series
I enter step level .....1 and I enter .. stop value..89 to end at 89.
 
Not sure what you are doing and/or asking here.

What has edit>fill series got to do with counting a list of things?

Please post back with more details of your actions and explain what the "bar to
left count" is.


Gord Dibben MS Excel MVP
 
I have a list of people to count. For example my boss want me to tell her how
many people are on program. I am using the edit fill series to manual count
the number of people on progam. I insert a new colum and simply add. 1, 2, 3
to the first couple of lines. Then press edit fill series. Check linear. Use
the start value as one and guess at the end value by looking at the column to
the left( the column that excel has that counts the number of lines that a
doccument has. I guess and stay the end time is 89. Since the last entry I
have is 89 since the column to the left is at 89 Yet sometimes the column to
left is off sometimes and when I press edit fill sometimes it skips numbers .

For example it can count number 1, 80 fine jumps next to 85 and continues
fine 86, 87, 88, 89. It is jumps in the edit fills option or press an end
count as 89 by looking to the columns to left which is sometimes skewy my
count is messed up.


Sorry bear with me. Look at any blank excel document . Look at the extreme
left. There is a little column that is pre-counted. This is what I mean when
I say column to the left. Both the the column to the left and my new created
edit fill column are sometimes off.
 
The "column to the left" is the row headers.

Perhaps you have some rows hidden or with a very tiny height?

If you want to count how many cells in a column have data just enter a formula
in a cell in an adjacent column.

=COUNTA(A:A) entered in B1 if your people are in column A.


Gord
 
Back
Top