Search results

Hi, I need to copy data from other file for the days of month. However, when I use hyperlink and drag it down/left/right .it does not pick correct values. How to do this linking for all days? Attaching file with sample data and kind of output I want I need to copy data from "Original...

Hi, I need to copy data from other file for the days of month. However, when I use hyperlink and drag it down/left/right .it does not pick correct values. How to do this linking for all days? Attaching file with sample data and kind of output I want I need to copy data from "Original...

Hi, I have two excel files. and when I use Vlookup to copy values from one file (sample original file) to another (similar file) , its not working for duplicates. After checking, I see there are lots of duplicates and its picking first value. How do I put it to get all values ? I tried to use...

Hi, I have below loan ammortization sheet. Now, the interest rate on the loan has changed from original (9.75) to (9.35) in Oct 2015. Can changes be made in same sheet so that I can see ammortization schedule with varying interest rates like Principal + interest (EMI) charged with 9.75 till...

Can anyone help with excel conditions to answer this. please help me for sheet1 the link is http://speedy.sh/hG8h6/book1.xls I got the logic , but i am unable to frame excel code for this(this has been my problem most of the times), so here we go the total addition is =opening output+...

Hi, Can anyone help with excel conditions to answer this..I have put two separate ques in same file, please answer both sheet1 and sheet2...the link is. http://speedy.sh/hG8h6/book1.xls thanks in advance

Hi, Just wanted to know..if some keys are here, I always have to type COMPLETE FORMULE like=vlookup, =sumif...I was wondering if we have some key combination ..where we can just select the particular one, and use it, instead of manually typing it?

Hi, I face this everytime, please tell if there is some easy way out doing better than what i currently do, I always have to deal with files, where I have to filter the sheet, then segregate individual common rows and columns and copy , paste to next blank worksheet, this becomes...

how to open excel files faster? especially heavy excel files?

hi, I have a file where I have to expand rows and columns..i use shortcuts-ALT+O+C+A (for columns) ALT+O+R+A( FOR ROWS) is there any way/key combination where I can expand both rows and columns at same time

Hi, I am uploading the link for 2 files..data.xls and citycodes.xls.. I am using Vlookup.in data file linked to city codes file..as shown in file..the output should be "quilon" ..in first cell and so on...BUT ITS SHOWING N/A..I am sure..my vlookup code is correct..whats problem? please help...

Hi, I was working with a file with 20 tabs in a single file.. Now the thing is..if we 2 excel sheets..we do ALT+TAB to go to last working sheet But is there any shortcut for multi tabs.. like suppose If I am working on 2 tab...and then i move to 18th tab...then again if i have to go to...

DPIS LOCATION DESC 17-Jan-06 Ambala-Ambala 0 22-Dec-05 Ambala-Ambala 0 22-Dec-05 Ambala-Ambala 1 30-Nov-05 Ambala-Ambala 0 31-Jan-06 Ambala-Ambala 0 31-Jan-06 Ambala-Ambala 1 I need to filter out duplicate entries, like I have to eliminate , same LOcation Desc different dpis...