| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generate a Modulus Sequence
Hi,
Hoping some Excel guru can spread some devine light on a problem thats quite knotty :) I need to generate a list of numbers that will follow a pre-defined Modulus 11 routine. Characteristics of the number are : 8 Digits long, Always begins with 5 and ends with a 1 or a 2. If the number ends with a 2 then add five to the weighting calculation and continue with Mod 11 to obtain the Check Digit. Weightings in character positions are 5,3,8,2,9,1, CheckDigit here , 1 or 2. Not sure how or if i would create a function for this !! Any Ideas... Any Takers..... TIA Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate random sequence based on probability | Excel Discussion (Misc queries) | |||
| How do I generate a Sequence Number System in Excel? | Excel Discussion (Misc queries) | |||
| Generate a special numerical sequence in Excel 97 | Excel Worksheet Functions | |||
| modulus 11 formula | Excel Worksheet Functions | |||
| GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Excel Discussion (Misc queries) | |||
Threaded Mode
