Search results

Hi, I have data in two sheets and i put some formulas in sheet1 by refering some cells in sheet2. Can i select all those referred cells in Sheet2 (where the cell i got result by refering cells in sheet2) with any keybord shortcut or is there any tip for this. Thanks-Sekhar

Hi, I'm trying solve this problem since five days but i didn't get correct solutions for this. Here we have two sheets, one is the data which i downloaded from software. Second one is format which we need to convert the data in the first sheet. I need to convert the data in the first sheet...

Hi Gurus, Thanks for lot of help and sharing your thoughts through this website. I have a problem that whenenver i am trying to open a existing workbook, it is opening along with a new workbook. I don't know what is reason behing this. I am using excel 2007 on Windows7. Please help me...

Hi, Thanks for the all help i got from here. I have uploaded a workbook, which contains data downloaded from my accounting package, formulas and final output. Following is the link........ https://dl.dropbox.com/u/86812629/test1..xls Please check column H,I,J,K in test worksheet and...

HI, We got lot of help form this website. We should thankful to all experts who are delivering their valuable ideas here. I have just posting some data here, can any body please try to develop some process. If it is possible, it' very useful to me. Please check attached file in the...

Hi, I have a worksheet containing 1000 columns with lot of data. The data in worksheet as follows.. AB (columns) (1,2,3,4 is rows) 1 Voucher No Narration 2 001 testing for excel 3 4 5 002 sales in south division 6 7 8 9 10 003 sales in north...

Hi, I have data in on worksheet as following.. columnA columnB 1 11 test1 2 test2 3 13 test3 4 5 6 7 14 The result should be following manner.. columnA columnB 1 11 test1 2 test1 3 13 test2 4 test2 5...

Hi, I have 750 pdf documents of my company's barnches. I need to seperate all those pdf documents branch wise. For that we need to open those pdf files through excel hyperlinks and save in folder (opened files). Please help me out on this. Thanks-Sekhar

Hi, Can any one help me out in this formula. COL B COL C COL E COL E COL F 1 dept a/c code Apr-11 May-11 Jun-11 2 123 500123 10 10 10 3 456 500124 11 11 11 4 789 500123 12 12 12 =INDEX(B2:F5,MATCH(B3&C3,B2:B5&C2:C5,),MATCH(C2,B2:F2)) Here, we need to match A3 and b3 in col a and...

Hi, I am working on the same thing since two days, bur i cann't find a solution for this. Here my requirement is to distributr the amount based on the START DATE AND END DATE. Following is the example....... paid exp payable #of Mon START END 01/01/11 01/02/11 01/03/11 01/04/11...

10399 Result 10400 1ADVANCECOMP10399/10400/10401/10405/10624/10625/10626/10627/106 30/10631/10657/10658 10401 1AIRCON 11240 10405 1AMSTAR 10145/10689 10624 10625 10626 10627 10630 10631 10657 10658 1ADVANCECOMP 11240 1AIRCON 10145 10689 1AMSTAR 1APIICL 11014 1BHARTI31...

Hi, I have problem with sumif,index and match formula. My data is as follows V.No. Particulars Debit Credit Category 1 test1 55 AP OFFICE 2 test2 60,000,000 CONTRA 3 test3 5,126 AP OFFICE 4 test4 120,603 TDS 100000 TDS Here we are using the sumif,index and match formula...

"Hi, I have the following problem, here we need to sum continuously find the duplicates in MP and get sum based on unique MP code on header. 511001 511105 MP BASIC HOUSE RENT ALLOWANCE 115 1 2 115 1 2 115 1 2 115 1...