| 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 |
| 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 | |||
Threaded Mode
