Search results

Thank you @PualF, @snjpverma.. i have incorporated both the suggestions, i.e using int() and mod() functions instead of date() and time() functions. And, also the new formula without helper column to calculate the TAT in H14 cell. When I give the received time before 3 pm, it is working fine...

Hi, I forgot to add some more clarity on point 2, if the email is received today after 3 pm, then the start time would start as tomorrow 8 am. And, on same criteria, if email is received today at 4 am, the start will apply only from today 8 am. This is also not working in my so assumed...

Hi Luke M, I tried the same but didn't work! I locked all the cells except for A1 cell. I put DV for B1 cell as =$a$1<>"" protected the sheet. I still see the B1 as protected, and even if I have entered some text in A1? How would this custom formula in DV helps to enable cell for editing...

Hi, I am using VBA in Excel to connect with Outlook Sent Items folder and save the mail item in shared network drive. The macro is working fine, the challenge I face is when I try to sort the sent item to pick recently sent item as first email. The below email do works in Outlook 2013...

Feel free to ask questions, if any. looking to get some solution. Regards, Prasad DN.

Hi All, I am trying to find the time taken to respond to the email received. so, I have time the email was received and the time email was responded. The catch or conditions are as follows: 1. Working hours - 8 am to 5 pm. 2. Email received after 3 pm, automatically considered as received...

I am back.. and will try to be connected with this site.. :)

Hi All, I choose this as title as it has been haunting me for quite long. :( We have an application called Filenet web application and in which supervisor logins and goes to workqueue tab, gives the from date and to date and selects queue, clicks refresh and the result shows list of tasks (13...

Hi, your data file seems to be one data.. what you want to separate in them? every new line in a separate cell? if yes, use vba.split() function with delimiter as Char(10) and store the array into rows or columns you want. Regards, Prasad DN

Hi i agree this would not be possible without VBAs. having said, in case you have a limited numbers then you may try to list it a separate sheet and do a vlookup() or any such formulae. This is just a workaround to cut VBA, but not ideal way to do. Regards, Prasad DN

hi, pls upload the same in excel file so that layout can be easily understood. Regards, Prasad DN

Hi As you do not know the customers name, give pseudo names to each customers products, like ProductsCust1, ProductsCust2 etc and use data validation in Column C, with Indirect("ProductsCust" & match(B2....)) See the example: =INDIRECT("ProductsCust"&(MATCH(B2,$H$1:$H$8,0)-1)) With this...

Hi Team, Background: I am working on tracking activities the shared mailbox and folders in it. Progress: I am able to track all the new emails incoming to specific shared mailbox inbox, and folder in it. I am stuck at a point in tracking who is moving the email from one folder to other...

Hi Ben, Refer the post from @Somendra Misra : http://chandoo.org/forum/threads/return-the-number-of-custom-calendar-days-that-overlap-two-time-periods.14858/#post-89044 For example in your file, for 2nd invoice, place this formula in I8 Cell...

Hi.. check if this solves your problem: =IF(OR(D3="Closed",D3="Transferred"),"C", IF(VALUE(RIGHT(M3,10))-VALUE(TODAY())<=$X$1,"R", IF(VALUE(RIGHT(M3,10))-VALUE(TODAY())<=$X$1+5,"Y", "G")))

Hi All, Most expected unexpected event :( I dont remember the password I set for the VBA code for my Outlook. In fact, I dont even recall setting password for the outlook VBA project. :( i tried google and could not find any help, as most of them are suggesting either paid software or...

Hi All, Most expected unexpected event :( I dont remember the password I set for the VBA code for my Outlook. In fact, I dont even recall setting password for the outlook VBA project. :( i tried google and could not find any help, as most of them are suggesting either paid software or...

will try these ... thank you!

Hi.. The file is not corrupted.. and I am able to open the file manually, without any issue, but challenge only when tried thru vba code. the environment does not have shared drive, all the files are sent to one individual thru email. That individual saves all the files in one location. And...

Hi All, I have made a template of excel file (.xlsm). And another excel macro file called consolidator. This template is shared with 10 different users, and they track the details in the template. All these 10 files are stored in one location, and consolidator macro file on click of command...

Hi Nebu.. I had earlier heard about this Solver and had never tried nor felt its requirement. Now, with this problem on hand, I had no other option but to learn and do. Finally the result, yes I could make use of Solver to solve my problem. Thank you. Regards, Prasad Dn

Hi, I have an interesting problem, and need help from any of you. Let me try to put my case as simple as possible, though it sounds very crazy for me myself. Now, let me explain what is Inventory here. I get cases which are called “NewTasks”. And once you work on it, it becomes “Follow Up”...

My bad luck: :S With Khalid's CSE approach, I am able to overcome this problem: with CSE: =SUM(IF(B$5:B19=F$5,IF(C6:C20=G6,D6:D20))) Regards, Prasad DN

Hi Again, I am running into another issue here.. due to "" being multiplied by true(1) or false(0). pls see the revised attached file. In the data range for sum, I have some cells which has formula like IFERROR(xxx,""). Unfortunately, i cannot use IFERROR(xxx,0), as it would affect the...

Thank you Hui!! i knew about sumproduct, but did not realise the change in array of two parameters. regards, Prasad DN PS: I should be good to go with this hint for rest of my work :) thank you.