PC Review


Reply
Thread Tools Rate Thread

to find missing serial numbers in randomly generated numbers

 
 
=?Utf-8?B?Qi5ILiBIYWRp?=
Guest
Posts: n/a
 
      1st Dec 2005
I have a set of randomly generated four digit numbersin ascending order. I
want to find out and make a list of all the left out 4 digits. Can you help
me
 
Reply With Quote
 
 
 
 
=?Utf-8?B?U3RlZmk=?=
Guest
Posts: n/a
 
      1st Dec 2005
Try this solution:
Assume that your 4 digit No's are in range(A2:An)!

Enter in B2:
=A3-A2 and fill it down as necessary
in C2:
=IF($B2=1,"",IF($A2+CELL("column",C$1)-2<$A3,$A2+CELL("column",C$1)-2,""))
and fill it right to last column (IV), and down as necessary!

In columns C:IV you get the left out . To say the truth there is a limit of
this solution: if more then 254 4 digits miss between two random No, then
those above 254 will not appear in the list!

Regards,
Stefi

„B.H. Hadi” ezt *rta:

> I have a set of randomly generated four digit numbersin ascending order. I
> want to find out and make a list of all the left out 4 digits. Can you help
> me

 
Reply With Quote
 
 
 
 
Herbert Seidenberg
Guest
Posts: n/a
 
      1st Dec 2005
Set up your data as shown:
set_rand set_all Criteria
10 10 11 test
13 11 12 TRUE
14 12 15
18 13 16
20 14 17
22 15 19
.... ... ...

For simplicity only 2 digits are used.
The first column contains your random numbers.
Fill in all the numbers from 10 to 99 in the second column.
Select the headers and the data below it for
set_rand, set_all and Criteria and
Insert > Name > Create > Top Row
Enter this formula into the TRUE cell:
=COUNTIF(set_rand,set_all)=0
Data > Filter > Advanced Filter
Copy to another location
List Range: select set_all and its header
Criteria Range: =Criteria
Copy to: anywhere or column 3 as shown

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
A Macro to find missing serial numbers in a column =?Utf-8?B?S2hvc2hyYXZhbg==?= Microsoft Excel Misc 9 6th Aug 2006 10:37 AM
How to read NIC card serial numbers or MAC address , Hard Drive serial numbers in Java or Delphi or C/C++ or C#? Ryan Liu Microsoft C# .NET 0 28th Apr 2006 04:57 AM
How random are randomly generated numbers ? Savvoulidis Iordanis Microsoft Access Form Coding 9 22nd Mar 2006 10:40 AM
Trouble Sorting Averages of Randomly Generated Numbers GStrawley Microsoft Excel Misc 3 5th Sep 2005 10:39 PM
inserting randomly generated numbers into a table Jim S Microsoft Excel Worksheet Functions 4 10th Feb 2004 08:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:38 AM.