Search results

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?

one thing more, My actual workplace sheet has 5 columns instead of 3 mentioned here, please advise

Hi luke M, thats pretty much..what I wanted but I am unable to put a macro..can u put the codes here and instructions on how to do it? ( I want this one -create a new sheet for all unique values)

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...

thanks sirjb7, it worked, just tell one more thing..is there any way if I can remember short cut assigned keys on tool bar or some link is shown for shortcut keys of a particular macros?

SORRY SIRJB7 AND LUKE, I am unable to put these macro codes, can u tell me how to do this? do we need to record it ?

thanks sirjb7, I checked out..the shorcut command is less time consuming..than clicks..between ..can u share the macro/vba code for this.I dont know excel vba/macros..will use it and then check which is faster!

Hi sirjb7, ya..exactly I meant resizing to fit the contents..I want to resize both column and rows at same time..in single shot

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 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 SirJB7, Thanks a lot, it worked with right()...I have some queries-why does same formula does not work if I use left(B2, 4) in vlook formulae? and how u got to know leading character is not a space (char 32) but a (char 160)..I am just into some excel(pivot table, some advacne commands)...

HI, substitute command not working..showing error-#NAME?

Hi sirjb7, after doing that,the answer in first cell..its showing is "0147" but it should show "quilon"..as corrosponding to 0071=quilon is there.. I am pretty sure..code is correct..can u point out mistake..?

Hi sirjb7, I tried it before..using trim() ..and i even converted the text to number format..somehow ..it doesnt works.

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 hui.., I changed some values..to check the formula..pls check..if its ok..as it always shows false..

hI HUI, can u elaborate on ur second shorcut? Like if i have one excel sheet with three tabs named-x1,x2,x3 I am on tab x3.. now if i want to move to x1..i type sheetx1!A1..this shows error....

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...

Hi hui, you are right..but we have to scroll the whole sheet..to see this..I had 10 such files..its tedious..I did it this way only.. So i wanted some way to see this better...for future.. what i wanted, I explained in the attached file..zeors etc... thanks

hi http://hotfile.com/dl/115372313/274a18f/extracts.xlsx.html Hi ninja..i have shared the file with what i want... I have taken first 10 rows of the sheet

http://hotfile.com/dl/115372313/274a18f/extracts.xlsx.html Hi ninja..i have shared the file with what i want... I have taken first 10 rows of the sheet

Hi ninja, Even in that Case..as u pointed out..it doesnt gives what I want..see here...we have diff DPIS(1 feb, 3 feb) same loc(Ambala...) so.it should show as false everyehere. This is the problem I face..some Dates are reapeated..like 1 feb and 3 feb are repeated again again..so I am not...

Pls do tell if i am still not able to convey..what i want..Pls see my prev posts

Hi ninja, this formula stil doesnt works.if u see the file.. 1-Feb-10 Ambala-ASB-1113,Kori Mandi,Ambala Sadar,,,,Amba TRUE 1-Feb-10 Ambala-ASB-1113,Kori Mandi,Ambala Sadar,,,,Amba TRUE 1-Feb-10 Ambala-ASB-1113,Kori Mandi,Ambala Sadar,,,,Amba TRUE 3-Feb-10 Ambala-ASB-1113,Kori Mandi,Ambala...