Generate training per quantity limit in each decade. *

**jorel** · 05-22-2018, 08:36 AM

Generate training per quantity limit in each decade
* So we have
* 01 to 10 = a
11 to 20 = b
21 to 31 = c
Position 1ª 2ª 3ª respectively abc
Ex = choose quantity of 4,1,2 =
* 4a
* 1 = b
* 2 = c
* Need a tee or field for
Define the amount of each letter

**Kaper** · 05-22-2018, 09:41 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**jorel** · 05-22-2018, 09:54 AM

ok KAPER,thank you!!

**jorel** · 05-22-2018, 10:14 AM

option to choose the quantity in each of the three groups
* with the endings and generate
https://www.excelforum.com/attachmen...1&d=1526998425

**jorel** · 05-22-2018, 10:19 AM

In the spreadsheet is an example both the letters and the last 10 digits have field or button to choose, or select the quantity and also the last digit
* Attention = I can choose 3,3,1 .... or 2,2,3 etc .... in the abc groups
On terminations or last digits also option to choose ok will not be fixed
* In lilac color it was just an example

**Kaper** · 05-22-2018, 01:30 PM

1. Make sure that your sample data are truly REPRESENTATIVE of your real input data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

**jorel** · 05-22-2018, 03:10 PM

In the example, the suit was chosen as the group A = 4 group B = 1 and group c = 2
Last digit = group A = 0,3,5,7,9 group B lastdigit = 4.7 group clast digit = 3,6,8
If you choose the suit and the last last digit

**Kaper** · 05-22-2018, 03:13 PM

Sorry, I do not follow this :-(

Generate training per quantity limit in each decade. *

LinkBack

Thread Tools

Rate This Thread

Display

Generate training per quantity limit in each decade. *

Re: Generate training per quantity limit in each decade. *

Re: Generate training per quantity limit in each decade. *

Re: Generate training per quantity limit in each decade. *

Re: Generate training per quantity limit in each decade. *

Re: Generate training per quantity limit in each decade. *

Re: Generate training per quantity limit in each decade. *

Re: Generate training per quantity limit in each decade. *

Thread Information

Users Browsing this Thread

Similar Threads

I'd like a cell to generate the sum of the QUANTITY of items from multiple cells

Hello! I work for DHS and I have been using excel for over a decade...

Hello! A decade ago I could write VBA...

Excel 2007 : Want to use Excel to generate a training schedule without conflicts

Data Validation to limit quantity for certain items

generate sequential numbers with a limit

[SOLVED] Trying to generate a quantity from a list of doors with varying at

Bookmarks

Bookmarks

Posting Permissions