Re: smallest missing number

Tech-Archive recommends: Fix windows errors by optimizing your registry


If they will always be in ascending order and always only 6 numbers then
the
following formula will work:

=IF(G1-F1>1,F1+1,IF(H1-G1>1,G1+1,IF(I1-H1>1,H1+1,IF(J1-I1>1,I1+1,IF(K1-J1>1,J1+1,K1+1)))))

Its not very elegant but it gets the job done. Perhaps someone else
will come
along with a simpler formula.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30153
View this thread: http://www.excelforum.com/showthread.php?threadid=513202

.

Relevant Pages

  • Re: RTL Qualifying Ride October 13th -14th
    ... The Coker isn't elegant, it's majestic ... saskatchewanian's Profile: http://www.unicyclist.com/profile/14180 ...
    (rec.sport.unicycling)
  • Re: unicyle of tomorrow
    ... The Coker isn't elegant, it's majestic ... saskatchewanian's Profile: http://www.unicyclist.com/profile/14180 ...
    (rec.sport.unicycling)
  • Re: Drop Down List
    ... I didnt have the list sorted in ascending order, so it wasnt working ... cbrd's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30009 ...
    (microsoft.public.excel.programming)
  • Re: iPhoto export photos, preserve dates?
    ... I tried this (very elegant) solution, ... mcpinroc's Profile: http://www.macosx.com/forums/member.php?userid=48180 ... Prev by Date: ...
    (comp.sys.mac.apps)
  • Re: Copying text value based on long (comlex) calculation
    ... I have combined all of the VLOOKUP calculations into one formula, ... It's not as elegant, but it would be a quick way to ... gezuvor's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30383 ... Prev by Date: ...
    (microsoft.public.excel.misc)