Skip to Content
0
Former Member
Mar 22, 2010 at 08:11 AM

formula for comparing

27 Views

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