Posted to microsoft.public.excel.misc

Chris_t_2k5

Posts: n/a

smallest missing number

Here is my problem,

I have numbers in cells F1:K1 eg, 1,2,3,5,6,7.

Is it possible to have in cell L1 a function / formula to display the
smallest missing number (ie. 4 in the example). The missing number can be
anything upto 15.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
number format	Ivan	Excel Discussion (Misc queries)	2	October 14th 05 02:08 PM
vlookup with more than number to be retrieved	martelie	Excel Worksheet Functions	3	October 14th 05 12:50 PM
vlookup with more than number to be retrieved	martelie	Excel Worksheet Functions	1	October 8th 05 07:33 AM
Count Number of Characters in a cell?	AHJuncti	Excel Discussion (Misc queries)	2	June 16th 05 07:39 PM
Need number of Saturdays and number of Sundays between 2 dates	Class316	Excel Worksheet Functions	1	June 10th 05 02:47 AM

All times are GMT +1. The time now is 09:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us