Hi,
While working in one of my excel 2007 file , i used link to take the amount from other sheet in same workbook , but the result it was displaying was 0, it was not picking up the amount from other sheet.Can anyone help me let know how this type of error arise
Hi,
I didnot get what you said Narayan, i have two excel files but i am not able to get the link. If i want to add one amount from my one workbook with other workbook , the links or formula disappears as i do Atl + Tab and go in next workbook or excel file to apply my formula.
Hi frndz,
I AM USING V LOOKUP FORMULA , I WANT TO EXTRACT THE DATA AS PER ANOTHER WORKBOOK DATA , BUT WHEN I PRESS ALT+ TAB AND GO IN OTHER WORKBOOK TO SELECT THE COLUM , THE FORMULA DOESNOT WORK .
CAN YOU PLEASE HELP ME WHY DOES THE EXEL NOT PICKING OR TAKING LINK FROM OTHER WORKBOOK????
Hie,
Can anyone help me in finding the diffrence between two hours.ie if if work at 11 am till 9.25 PM , difference between them.
I have tried many formula but it showing error as value
Hi ,
My query is i have list of name in one column and the same name is in other column , but they are not in sequence.eg, Ritesh kumar in one column vis a vis kumar nitesh in other column , now i want to match .
Plaese help me on this query
yes, if press the Ctrl+; it shows date but i want to paste the data in the filter portion but the same is also pasted in the hidden rows.Can anyone please help me on this
I have a data file in which i have applied filter, while pasting the content or formula from other workbook the content gets copied on the row which are hidden.Is there any shotcut key or way to overcome this