Hello Gurus,
could you give me any suggestions on how to write VBA script to group lines with same ID(they are different in values) for further scenario breakdowns? A simplified table is shown below. Thanks!
could you give me any suggestions on how to write VBA script to group lines with same ID(they are different in values) for further scenario breakdowns? A simplified table is shown below. Thanks!
ID | Value |
A | 1 |
B | 3 |
B | 1 |
C | 10 |
C | 1 |
C | 2 |