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?
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?
If it would be like 1,3,7,9,13,14,15,16,18,20 then you can create a list of
numbers 1 to 20 (assume they are in A1:A20), then adjacent to that list use
a formula like
=IF(ISNUMBER(MATCH(A1,MySequence,0)),"",A1)
where MySequence is the list you want to check, copy down to B20
--
Regards,
Peo Sjoblom
(No private emails please)
"Nash" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks