Dear Expert,
I have data as below:
Row DocNo ItemCode Desc
1 1000001 101 A
2 1000001 102 B
3 1000001 103 C
1 1000002 105 D
2 1000002 106 E
3 1000002 107 F
Row DocNo ItemCode Desc FORMULA (Desc)
1 1000001 101 A A
2 1000001 102 B *A
3 1000001 103 C *A
How to make a formula where the 2nd or 3rd will follow above 1 st row ?
Thanks.
Your reply is highly appreciated.
Regards,
Danny