增加偶数和奇数的se ..

问题描述:





在A栏中,数据是这样的。

............结果字段B和C



A ............. B ........... C >
1A ......... 1A .......数学

数学..... 1B ...... Hin

1B .......... 1C ...... Eng

Hin ......... 2A ...... Sci
1C

Eng

2A

Sci

...

...



Plz在B&C栏上给出公式

Hi,

In column A Data is Like This.
............Result field B And C

A.............B...........C
1A.........1A.......Math
Math.....1B......Hin
1B..........1C......Eng
Hin.........2A......Sci
1C
Eng
2A
Sci
...
...

Plz give the formula on Column B & C