Data_SystemAnal
8 months ago

# Created A,B and C gruop of 10 records

Hello all

I need help

does anybody know a formula for creating a group of 10 records and labeling those records as A, B etch based on levels 1, 2, 3, etc?

Level 1, max 10 records = "A"

level 1   Max 10 records = B, etc etc

------------------------------
------------------------------

### 15 Replies

• Can you give us an example of what you mean, some example data, and how it would be coded.

------------------------------
mark.shnier@gmail.com
------------------------------
• Hi Mark (Happy Holidays)

Yes. For example, I said that I have 100 records.

I need to create groups of 10 records, so let's. I am saying that I have 50 records set at level one (1) and 50 defined at level two (2), so the formula I am looking to create will set a letter for each group.

GED-Level 1-A; GED-Level 1-B; GED-Level 1-C.....
GED-Level 2-A; GED-Level 2-B; GED-Level 2-C.....

I should end with

5 grups (A,B,C,D,E) for Level 1 and
5 grups (A,B,C,D,E) for Level 2

Plus, if more records are created, the number of groups increases.

Fields

• Level
• record id
• program (GED)

I hope makes sense.

100/10 will end with 10 groups that each grup will have a letter that represents it.

------------------------------