Search results

  1. I

    Split table in 4 equivalent parts by 3 criteria

    Yes, but how can I use this method and keep the number of records equal across all groups (in each category), considering the fact that a user can have records in different categories. Cumulating the values at UserID level eliminates the posibility of having equal groups at category level.
  2. I

    Split table in 4 equivalent parts by 3 criteria

    1. MOD approach: I tried that already in Excel and it didn't solve my problem because Value1 and Value2 were very different between groups. 2. Value1+Value2 approach Value1 is considerably larger then Value2 Frothingslosh, that is a very accurate description of my problem, i know it is very...
  3. I

    Split table in 4 equivalent parts by 3 criteria

    Thanks for your answer, let me give you more details to help you understand my situation. My table looks like this, and i have approx. 8000 records (use text to column separator " "): ID UserID Category Value1 Value2 Group 351520 1801129226 B1 5,140.33 115.61 Group1 1430584 2850323070...
  4. I

    Split table in 4 equivalent parts by 3 criteria

    Hi all, I have a table with the folowing structure: ID(integer) Value1(Double) Value2(Double) I need to split this table in 4 equals parts: - count of id must be equal or close to equal(ex: 467 split in 3 x 117 and 116) for each part - the cumulated Value1 and Value2 must be equal or close to...
Back
Top Bottom