| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find gaps or breaks in a large column
In B1 enter:
=IF(A2=A1+1,"","XXX") and copy down Non-blanks are where the gaps are. -- Gary''s Student - gsnu200722 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find gaps or breaks in a large column
One way. In the second to top row of data click format|conditional
format|cell value is|greater than|=$A1+1 and then select a colour (say red) and click OK. Click on the format painter and paint this format into all your range of cells and where there are gaps it will turn red. Mike "Compare Values" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find gaps or breaks in a large column
Thank you.
"Gary''s Student" wrote: In B1 enter: =IF(A2=A1+1,"","XXX") and copy down Non-blanks are where the gaps are. -- Gary''s Student - gsnu200722 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find gaps or breaks in a large column
Thank you
"Mike H" wrote: One way. In the second to top row of data click format|conditional format|cell value is|greater than|=$A1+1 and then select a colour (say red) and click OK. Click on the format painter and paint this format into all your range of cells and where there are gaps it will turn red. Mike "Compare Values" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| serial numbers how to find gaps | New Users to Excel | |||
| Minimize range on vertical axis with large data gaps | Charts and Charting in Excel | |||
| How I can find breaks in continuity | Excel Worksheet Functions | |||
| Transpose Column With Gaps to Row With No Gaps? | Excel Discussion (Misc queries) | |||
| Lookup values in a column and display them in order with no gaps | Excel Worksheet Functions | |||
Linear Mode
