LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Finding missing values in a column

I'm looking for a way to automaticaly find missing values in a column of
numbers. Here's an example (all values are in the same column):

50
51
52
54
55

Value 53 is missing from the column (which should be increasing by 1 every
row). Is there a way to automatically detect that there is a gap between 2
values?

Thanks


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding the first and last column with values Epmo Excel Discussion (Misc queries) 1 February 6th 07 05:42 PM
Finding test strings in a row which are missing from a column TonyStarr at cox dot net Excel Worksheet Functions 0 August 20th 06 10:05 PM
Finding (Multiple) Highest Values in Column Shay Hurley Excel Worksheet Functions 1 October 3rd 05 04:19 PM
Finding Unique Values in Column Kirk P. Excel Discussion (Misc queries) 1 January 25th 05 02:01 PM
Finding the max of a column where values less than a specified number Mark Silka Excel Worksheet Functions 1 November 17th 04 03:14 PM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"