# Summarize Numeric Breaks

This is a discussion on Summarize Numeric Breaks within the Excel Questions forums, part of the Question Forums category; wrote a formula to look at the cells that are numeric and to find a break in the sequence. Now ...

1. ## Summarize Numeric Breaks

wrote a formula to look at the cells that are numeric and to find a break in the sequence. Now what I need is to do is look at the True and False cells and summarize in adjacent cells the numeric breaks. How do I do this? Should I even be using the True and False formula?
```
Here's what I would like to see:  12 15
17 21
22

12		TRUE
13		TRUE
14		TRUE
15		FALSE
17		TRUE
18		TRUE
19		TRUE
20		TRUE
21		TRUE
22		FALSE```

2. ## Re: Summarize Numeric Breaks

If you numbers where in column A, starting at A1, then would somehting like this work?

In cell B2, enter =A2-A1=1 and copy down for you entire range. It will return TRUE if the numbers are in sequence, else it will return FALSE.

3. ## Re: Summarize Numeric Breaks

I've got the True and False working, now I would like to take the cells that are true and go left and get the values in A1 and summarize the breaks. Is that possible?

4. ## Re: Summarize Numeric Breaks

What do you mean by "summarize the breaks"?

5. ## Re: Summarize Numeric Breaks

I want to summarize where their is a break in the sequence of numbers.

6. ## Re: Summarize Numeric Breaks

HOW do you want them summarized? What EXACTLY is it that you want to appear?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•