Search results

Hi Somendra, Thanks for the reply, however my intention wasn't like somebody would reply to my query in a moment. Thanks for your suggestion but my issue didn't get solved.I'll try otherways.

Hi Experts, Please help..!!!

In addition to the above query, i'm unable to sort the data. Please have a look. the requirements are mentioned in the sheet. I have created the macro & attached the sheet. Please solve my query.

Thanx alott.....Debraj. Thanx somendra, i'll try your formula too.

Hi Experts, I need a solution to sort the data on basis of location & highest marks. For this, i have created a dynamic named range to call it by macro & then sort. My problem comes when the range also selects the blank formulas in sheet which shouldn't be selected. Only visible data should...

Hey thanku so much Haseeb & Debraj. I found these ways by only you guys..!!!

yeahhhhhhhh...............It works....thnku so much....

Nopes....actually i want that for Neha..in type "HD", if the status is completed or not completed or both, then it would sum that amount otherwise if any other status comes up, then it wouldn't add that amount.

please use this file.

Hi Experts, I want to sum the values on basis of the status.I know it would get solved through if condition but still didn't got the exact match of formulas to get the results. Please help me with the solution. PFA file for reference.

Thnks Faseeh

ohh yes... it works. Can you please explain this.i know you have used array but I never got this Lookup formula.

Thanks Narayan sir & Kchiba sir. I have a query to Kchiba, only one problem is coming is that when the value is 16, it gives the score of 5 whereas it should give 4. please look in to this & also clear my one more query for vlookup that vlookup only looks for the specific value whereas in this...

Hi Experts, I'm trying to calculate the score on basis of a range table. For this, i have used the nested if statement however, i'm unable to get the accurate result. Please help me on this. I have attached the file for your reference.

Thanks once again....you cleared my concepts...!!!

hey Narayan, sorry for again disturbing bt can't do anything. While running same macro on selecting ques no., it doesn't display required result.please look in to this.this is the same code provided by you. please last time look in to this & try to give me a fix solution. here is the...

Thanks a ton sir..!!! :)

Hi Narayan, Thanks so much for helping in my silly questions.It's working.appreciate your help. Now my last problem is to make unique list for criterias.There are many domains & project id's which can't be entered manually so many times.I'm trying to create a unique criteria list from base...

Yes sir,i'm using the file provided by you & running this macro each time when i change any of criteria. I have attached the same with my issue on below link.please refer this. http://www.2shared.com/file/KaLqmLss/rough_1_.html

sorry for the inconvenience but i need the data as explained in above post. If only i'm selecting domain & rest of the two criterias are blank, then no data is retrieved.It's displaying blank data. please try this at your end & let me know if i'm doing anything wrong.

plz experts...help me with a solution...

Thanks for the reply sir bt it doesn't solve my purpose.Let me try one more time to explain. What i want is that when i select domain, then, only name & accuracy in that domain will display on report sheet.. then ,if i select any project in that domain, then it's correponding name & accuracy...

hi Experts, I'm in a great problem as i'm beginner in macros.I have created a template in which the data would be extracted on basis on 3 criterias.However, by using macro, i'm unable to extract it.For criterias, i have created drop-down list by using Data validation & name manager. my...

thanks luke.

Hi Experts, I need your help in one of my problem.I want to consolidate the multiple excel files of a folder with same name & numbered as 1,2,3 in to a one excel file.I have tried but unable to create a macro on it.There is only one criteria in this consolidation is that column D of every...