Need a Excel sheet with Macro with the following functionality
- Assign Group id (Group1, Group2...)to each record ? based on a value (Language) in a column . i.e assign Group1 to each record and after 50 records assign Group2 and so on. If the value in the ? Language column changes start with Group1 again.
Once I run the macro, the data with same Language should be classified into Groups of 50 records each.