Hi!
Here's one way.....
Assume you have in A1:A9
1
2
3
4
5
7
8
9
10
6 is the missing value.
Array entered using the key combo of CTRL,SHIFT,ENTER:
=INDEX(ROW(INDIRECT(A1&":"&A9)),MATCH(0,COUNTIF(A1 :A9,ROW(INDIRECT(A1&":"&A9))),0))
Biff
"Nash" wrote in message
...
Looking for a function or formula that will identify a missing number in a
range of cells containing a sequence of numbers.
Can anyone help?
|