Search results

Hi, I have posted the workbook agagin in the following link with comments and demo also.it will clear the picture for you. http://www.fileconvoy.com/dfl.php?id=g81c538fb97070a87999331522a0f36a7321b53388 Regards, Rahul

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

thanks a lot hui and narayank991 for replying "FAST" which is not under the rules on this site.thanks a lot.

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

please send the link of www.fileconvoy.com i can open only link from this site only.

ok will take care in future

i am using excel 2007 and text filter and contains options are not there in this version.i have to do it with formula.

ok thanks

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

thanks a lot webmax

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

yes its working you both were right.i forgot to execute the formula with ctrl+shift+enter. thanks a lot again

this formula is working for the first cell but when i am dragging it down its showing n/a for the rest of the 3 values.

haahaha instead World Health Organization should take sincere steps to ban keyboard manufacturing companies from putting caps and num lock keys or everytime the user presses it they should charge caps and num lock keys pressed per stroke from manufacturing companies. hehehe Regards, Rahul

thanks SP

Hi Lisap, Can you explain me in your masterlist sheet from a2:h2 you have used the below mentioned formula. =IF(ISBLANK('C:Documents and SettingsuserMy DocumentsDownloads[NEW STARTER LIST.xls]2007-2009'!P2),"",'C:Documents and SettingsuserMy DocumentsDownloads[NEW STARTER...

OK OK THANKS BRO

NOW I AM USING THE BELOW MENTIONED FORMULA USING INDEX MATCH ITS SHOWING THE RESULT IN G2 BUT NOT IN G3 G4 AND G5. =VLOOKUP(E2&F2,CHOOSE({1,2},$A$2:$A$5&$B$2:$B$5,$C$2:$C$5),2,0)

narayank991 in masterlist i am not understanding the formula from a2 to h2 like for example in h2 its =IF(ISBLANK('C:Documents and SettingsuserMy DocumentsDownloads[NEW STARTER LIST.xls]2007-2009'!P2),"",'C:Documents and SettingsuserMy DocumentsDownloads[NEW STARTER LIST.xls]2007-2009'!P2)

Hi Phil, Here is your simple solution to your query. sending you as attachment http://www.fileconvoy.com/dfl.php?id=ga43765ba53ae24a1999302507c60d19ebd79d3470 Regards, Rahul

Hi Lisap, Can you send me this https://www.dropbox.com/s/rtqrxuvx6aw9v8a/LEAVERS%20LIST.xlsx file link on http://www.fileconvoy.com/ which narayank991 has send to you. Regards, Rahul

by the way debraj in your above post i am not having any idea why you have use IF({1,0}. what is this suggesting and why 1 and 0 why not any other number. kindly clarify. {=VLOOKUP(E2&F2,IF({1,0},$A$2:$A$5&$B$2:$B$5,$C$2:$C$5),2,0)} Regards, Rahul

thanks faseeh and debraj thanks a lot

http://www.fileconvoy.com/dfl.php?id=gb4e8cdf2845c401f9993019095648ba15452e59a1 Regards, Rahul