Search results

Hi VDS, Please let me know if below mentioned steps work :- 1) change the format of the data to general for which you want to change and select the columns in which changes needed. 2) Press Control+H 3) Type .* in find what 4) replace with field leave blank and click on replace all. Please...

Hi Narayan, If any other workaround or any change in my current dashboard can help to calculate this ? thanks for your valuable suggestion. Regards, Rajender

Hi Narayan, there is a small difference of amount may be due to ROE, I interlinked the file with online prices. In current the prices are showing as 1. Approved budget : 25,55,333 25,52,444 2. Estimated Cost : 12,37,757 12,37,380 3. Remaining Amt. : 13,17,477 13,15,064 4. Amt. per...

Hi Narayan, For current inputs which are selected in this file the results show correct , but when I am changing my inputs in summary sheet to another country it shows wrong result: for example I changed the input in summary sheet as below :- Select Country Netherlands No. of resources...

Hi Narayan, I want 0 weeks instead of days in that case. Also I want to know the 15,193 is the average of Approved budget cost & actual expense 5,21,868(Cell J3) , so i am not sure if average of approved budget we need to refer or Average of actual expenses we need to take. Regards, Rajender

Hi Narayan, Thanks for your prompt assistance. but I need the answer in weeks , when i am replacing given the formula in Tracker than it showing 2 more days instead of "week" , also the output showing as 2 days. Could you please assist for the logic to convert the same into week. this cell I...

Hi Luke, I uploaded the file in below given link. https://onedrive.live.com/?cid=393CD98CEE2A349F&id=393CD98CEE2A349F!105 if above link not work than please use https://onedrive.live.com/redir?resid=393CD98CEE2A349F%21115 Regards, Rajender

Hi All, I have two sheet in a workbook, 1 sheet named Summary & 2nd Data In Summary sheet I am taking input from User for country name selection , No of resourses, & KT duration(In weeks) in cells D6,G6 & J6 respectively. Now in data sheet cell contains the following values: K26 : Total...

Hi All, I am preparing a Budget Forecasting tracker in which I have to capture all the traveling details of 20 countries(which contains expenses like Ticket cost , Visa cost , Accommodation etc.......) I want to know if it is possible to link excel with any site from where we can link excel...

Noted with thanks.

Thanks a lot Narayan, Yes the file is in shared mode and multiple users are working at same time. Also I check out the below given link, where for Formatted cells or data track changes is not applicable. Could you please suggest if is there any other workaround, to track which user...

Hi All, I have an excel file in shared location. Now issue I am facing now is that every time my team mates complaining that they are updating that tracker but after 1-2 days the changes they made there are not available in it. For that I use Track changes option to cross check why/who is...

Many thanks Somendra. I applied the same format in my tracker. Have a nice day to you. If possible can you also help me on my another query in below given link http://chandoo.org/forum/threads/automate-create-multiple-files-based-on-cell-values.14110/#post-83941 Thanks in advance. Regards...

Hi Somender, I need one more assistance from your side. If I also want to apply a formula to count how many times every individual got top performer of the week at year end then what will be function ? Regards, Rajender

Hi Somender, Many thanks :-) its working more better now after covering your suggestive point :-). Regards, Rajender

oooh I forget this point. If is it also possible that at least two person name reflect if they have equal score ? Regards, Rajender

Hi Somendra, Thanks a lot for your assistance. Its working fine. but I changed the Max with Min as in my case the person who did least mistakes will be the top performer. Once again thanks a lot :-) Regards, Rajender

uploaded

Hi All, Can anybody suggest me the formula to extract the name of person according to current week number. my data range is from A3:BB7 Name Total Issues 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50...

Hi All, Awaiting for your expert assistance. Thanks a lot for your suggestions and solution in advance Regards Rajender

Hi All, First of all I am very thankful to all of the members of this site. I learned a lot from this site and applying the same in daily routine work and appriciated by all of my team mates and Managers. Thank you all. Now I am learning about macros. Few days back I saw 1 of post about...

Hi Bobhc, your message well noted :-) I just tried the same its working fine for me. I have only 1 query now : if is there any issue to un-check this option ? because this was previously tick mark by default. Thanks for your valuable feedback. Regards, Rajender

Hi All, From last 2-3 days a below message box showing while I am saving excel file. Can anybody suggest why this message box showing and how to remove it ? "Privacy warning : This document contains macro, Active X control, xml expansion pack information , or web component ,this may include...

Hi All, Can anybody suggest the reason or solution for above problem. Regards, Rajender

Thanks a lot BBD. its working file :-) Regards, Rajender