Search results

i am posting the file with the link. all i need in this file is that cell a1 value should be get filled down till the next new cell comes with different vale and then fill the second value till next rows till the next new value comes. one thing to keep in mind is that their is difference in...

Hi, i want that if a student passed in 4 or more subjects it should show the aggregate result in cell d9 as pass else if student failed in more than 4 subjects than it should show fail in d9. link for sheet1 problem mentioned below...

below is the link for file http://www.fileconvoy.com/dfl.php?id=g4bc98b0fb6d7a7f39993159481a0fae723975d29e i want empcode corresponding to the names.if there are duplicate names the empcode assigned to duplicate names should have same code. Regards, Rahul

I have data in sheet1. i want that based on name of company column all the corresponding details of that column should be placed in sheet2. Like if a2 is the name of college whole of the information of the corresponding row should be placed in sheet2,likewise i need to segregate all colleges...

i am not getting correct result in c2 column and down using vlookup approach instead of if condition.below is the link for file. http://www.fileconvoy.com/dfl.php?id=gab0329ab80a475c1999307434d4c78545a2825501 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

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

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

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

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

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

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

I am attaching an excel file as my query. In the file in cell b28 i am applying index match formula but its not working showing ref# error.Some minor mistake is their but i am not able to figure it out. Kindly fix the error with the same index match formula.Plz reply and send the file on...

Hi, Can anyone give me a step by step creating dashboard in excel 2007 showing formulas. Thanks Rahul

The idea being that if VLOOKUP doesn't find a match on the first sheet, it will check the next sheet and so on. like if in sheet1 we have product code aand price columns with 100 product codes given. next we have 10 sheets from sheet2 to sheet11 with product code aand price columns duly...