Hi,
I have the below table, what I need is to sort the numbering by ascending order, it's easy if I have a fixed table, but the challenge is this table is dynamic, it changes whenever I change the EE ID. Can you help me with the formula that solve this issue?
<tbody>
</tbody>
Thank you
I have the below table, what I need is to sort the numbering by ascending order, it's easy if I have a fixed table, but the challenge is this table is dynamic, it changes whenever I change the EE ID. Can you help me with the formula that solve this issue?
EE ID | AAAA | ||||||
KEY_EEID | Goal# | Goal Overall Progress | Objective | Category | Metric/Outcomes | Active/Deleted | Numbering |
AAAA1 | 1 | NO | BBBBBB | OE | nnnnn | Active | 3.2 |
AAAA2 | 2 | NO | CCCCC | OE | jjjjj | Active | 3.1 |
AAAA3 | 3 | YES | KKKK | BE | eee | Active | 4.2 |
AAAA4 | 4 | YES | LLLL | OE | rrr | Active | 1.1 |
<tbody>
</tbody>
Thank you