P
PERANISH
example
col-A COL-B COL-C COL-D COL-E
AA 1 C/S F 05.APR.08
AA 4 S/S S 02.MAY.08
BB 2 C/S S 03.MAY.08
CC 1 C/S F 10.APR.08
AA 0.5 C/S F
DD 2 A/S S
BB 10 C/S F
I WANT THE RESULT IF COL-A=AA, IF COL-E = NON BLANK OR DATE,IF COL-D=S,
COL-B <2, SUM(COL-B)
PLEASE HELP IN THIS
MAX NO OF ROWS MAY BE UPTO 40000 DATAS.
AWAITING YOUR HELP UREGENT PLEASE
S.P.SAMY
col-A COL-B COL-C COL-D COL-E
AA 1 C/S F 05.APR.08
AA 4 S/S S 02.MAY.08
BB 2 C/S S 03.MAY.08
CC 1 C/S F 10.APR.08
AA 0.5 C/S F
DD 2 A/S S
BB 10 C/S F
I WANT THE RESULT IF COL-A=AA, IF COL-E = NON BLANK OR DATE,IF COL-D=S,
COL-B <2, SUM(COL-B)
PLEASE HELP IN THIS
MAX NO OF ROWS MAY BE UPTO 40000 DATAS.
AWAITING YOUR HELP UREGENT PLEASE
S.P.SAMY