### Similar Threads:

1.Need gaps, not zeros for charts!

2.Minimize range on vertical axis with large data gaps

I am tracking the percent of sales by product catagory for a company. They
have low percents for everything but one area. I mean, most product areas
are less than 10% while one is 60%. I want to remove the distance between
the 60% product catagory and all the others but still showing accurate data.
I would like to remove 20% - 50% since there is no data for that area. Is
that possible?

3.Deleting large gaps in address

I am using a large Excel spreadsheet to address my letters using mail merge.
When I merge some of the addressee names have multiple spaces between the
first and the last name. How can I clear this up in my spreadsheet before I
merge without doing it manually.

4.Find gaps or breaks in a large column

I have a very large column and I need to find out where the breaks or gaps
are. Example on the below column #1793675 and 1793682 are not listed. Can you
please advise a formula to check them?
1793672
1793673
1793674
1793676
1793677
1793678
1793679
1793680
1793681
1793683

5.Calculating largest gap in a series of consecutive numbers

Hiya,
I am currently trying to calculate the largest gap in a series of numbers
where a particular number has not appeared and display this number in a cell.
For example,
There are 2 numbers involved, 0 and 1. My spreadsheet looks like:
A1
A2 1
A3 0
A4 0
A5 0
A6 0
A7 1
A8 0
A9 0 and so on.....
Now, in cell C1 I want excel to automatically calculate the number of times
0 has come up consecutively up to the last time the number 1 appeared. So
when inputting data downwards in A10, A11, A12 it will be able to tell me how
many consecutive 0's there have been until the last number 1 appeared.
In the above example, if I had input the data upto A5, C1 would display the
number 3 (there have been three 0's since the last 1 came up). When A6 is
filled in with a 0, C1 would display 4, yet once A7 had been filled in the
counter would reset back to 0 in C1.
I have tried to explain this as best as I can, if you need any clarification
please ask, and thank you kindly in advance,

6. I need to copy a large chart from excel

7. Transpose Column With Gaps to Column With no gaps

8. LARGE 1, LARGE 2, LARGE 3, LARGE 4