Search results

Thanks Hui ! That was quite clever thinking... i think i'll remember creating this kind of helper cells in future..

^^^^^^^ I think there is li'l mess up in sample n source data posting... source> contract no 2,3,4..Inst No 1 to 10 and Remarks like qwr, re, rr... Output file Contract no 2,3,4... Inst No 1 to 10 in rows..And remarks value for each contract for respective inst no..

Let us assume following as source file: Contrac Inst No Remarks 2 1 qwr 2 2 re 2 3 rr 2 4 23 2 5 rt 2 6 c 2 7 ggg 2 8 hr 2 9 jnjj 2 10 jng 3 1 ppp 3 2 ttt 3 3 yyy 3 4 uuu 3 5 iiii 3 6 kkkk 3 7 lll 3 8 555 3 9 666 3 10 777 4 1 sss 4 2 cccc 4 3 $$$ 4 4 ooo 4 5 mmm 4 6...

I could not figure out what title to give to my question and hence... My question is I have a set of contract numbers with repayment schedule (showing each installment from inst. no. 1 to 48)..with the breakup principal, interest, insurance... Now in another sheet I want to just pull All...

Hello everybody ! This is Tasin .. I am working as an IT Manager with Credit Agricole Consumer Finance... I do lots of work related with data and hence love to see excel always behind me to help me. Though I have been using Excel for quite sometime now but i still yearn to learn new things in...