Hi Experts,
I stuck with more problem, let me clear you by seeing the new attached file. I am not a native Englishman, so, I tried my best to explain my problem in Excel Sheet in new attached file. Please help me to get it done.
Requiremtns
I want the same result in E2 to E**** with upper instruction in Cell F2:G14 by using formula
Account Type Requirements
CD Account no. (Cell B2:B***) which start with 111 & 131
SB Account no. (Cell B2:B***) which start with 12
MTDR Account no. (Cell B2:B***) which start with 2
SCHEME Account no. (Cell B2:B***) which start with 3
LOAN Account no. (Cell B2:B***) which start with 7
PL Account no. (Cell B2:B***) which start with 903, 904
PO Account No. 90211010009
CLG Account No. 90113200068
IBTA Account No. 90131010010
OTHERS Account no. (Cell B2:B***) which start with 901, 902; Except Account No. PO, CLG & IBTA Account (90211010009, 90113200068 & 90131010010)
Again thanks for helping me.
Regards
rif
Bookmarks