Search results

click the link and download the excel file.this is what you want as your solution. Regards, Rahul

hi lisap, use the below mentioned link to post your file. http://www.fileconvoy.com/ and then paste the link after uploading your file,so that we can have a clearer look at your problem. Regards, Rahul

i am sending the file as link. my problem is that i am not getting the resultlt in G2 column when i am combining e2&f2 as lookup value. http://www.fileconvoy.com/dfl.php?id=gdaa82ba510ec9933999301878322f2d5d45d5d9e5

now thats called hiting the bulls eye thanks a lot HUI

sorry folks the above mentioned formula didnt work so i am again sending the file with the below mentioned link,with what i want is mentioned in excel file in a line. i want either sumproduct or sumifs formula to do this...

i mean based on employee for example "callum" and based on date criteria where date should be from 01/05/2011 to 31/05/2011 sum overtime values that fulfill this criteria.

All i want is a combined formula in one cell.

I want to get sum of overtime values based on date criteria for may month only.below is the link. http://www.fileconvoy.com/dfl.php?id=g9eb0fb36a6cf65a8999297153cfa3ccb0f36f3e1d

OK ANY WAY THE BIG THING IS THAT OUR PROBLEM GET SOLVED THANKS A LOT ONCE AGAIN

thanks narayan problem solved. now just want to know can we cut short the formula in the description column with the use of indirect and vlookup only. i might have a feeling that the formula can be cut short to somewhat minimum and easy to understand. thanks rahul

i am not getting the last 3 values.i dont know why. here is the link http://www.fileconvoy.com/dfl.php?id=g6398dc0bf3cb5bbf9992930981a31304ad22e42de thanks, rahul

thanks a lot faseeh for a quick and obvious correct reply.

Kindly send me the answer in k21 cell http://www.fileconvoy.com/dfl.php?id=g62e965739ce772d19992922715770c42204f74517

waiting for anyone reply sorry but i need the answer some what early

kindly help with the above problem and post the excel file for the same link on fileconvoy site

sorry bobhc will make it sure for future questions.

this is the link to my excel file i want the data to be get transposed with formula kindly help http://www.fileconvoy.com/dfl.php?id=g78fd2eefe1c08e5f9992724659771636b8f95ca7f

Akay Agencies 1576, Bhagirath Place, Chandni Chowk, Delhi-110 006. Phones : 22964596, 22964783. Albert David Ltd.  4/11, Asaf Ali Road, New Delhi-110 002. Phones : 23270220, 23277667. I have 1000 entries in excel 2007 like the one above as shown in a single comumn A having company...

thanks a lot hui and kevin formulas working except for 2 names with / sign regards, rahul

Hi Hui, i have Mr. Anil Mehta919829042971udaipur@arihantbearing.com in one cell and Mr. H.S. Bhandari / Rajiv Bhandari9414126710etepl@rediffmail.com in second cell in the same column likewise 100 details with name,mobile number and email id. just want name ,mobile number and email id to get...

Hi, these are two data in two cells.all i want that Mr anil mehta name should be separated with mobile number and email id in 3 different columns. kindly suggest a formula. Mr. Anil Mehta919829042971udaipur@arihantbearing.com Mr. H.S. Bhandari / Rajiv Bhandari9414126710etepl@rediffmail.com

Hi sgmpatnaik, thanks a lot bro Regards, Rahul

Hi Raja, I am not able to unhide the source sheet.rest i had done like unprotecting the sheet and checked name manager. in name manager every formula consists of source sheet that only i am unable to unhide plz tell me how to unhide the sheet with name source. regards, Rahul

Hi Kaushik, http://vindeep.com/Models/HRDashboard.aspx i opened this above mentioned link and the corresponding site is opening vindeep.com I opened the download hr dashboard,excel has opened but i ma not able to view the source file tab in excel so that i can view formulas. kindly help...

I am attaching an excel as attachment. https://hotfile.com/dl/184288083/44bd6ee/Book1122.xlsm.html my question is that as you see in sheet1 there is a command button with name sales 2009 when you click on it a chart get displayed showing sales for 2009.But i am unable to generate chart for...