Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
no | required output | |
1 | 1 | |
1 | 1 | |
2 | 2 | |
3 | 3 | |
3 | 3 |
I have a column no (as shown above) ,i want it to transform into the required output.
Regards,
Ganesh.
no | A | B | =rowno(total) |
1 | x | a | 1 |
1 | x | b | 2 |
2 | x | c | 3 |
3 | y | d | 4 |
3 | y | r | 5 |
4 | t | t | 6 |
5 | t | t | 7 |
the output should be as follows :
1 |
1 |
2 |
3 |
3 |
4 |
5 |
Hi
if i understood your question.
in the output filed, just give =no.
Regards
Ren