jul-17

I want to know how to write a formula for last productiondate; if the well has produced for 3 consecutive months it would put the datein the box for me…. I have 10 years worth of data and it will need to pick the most recent - 3 consecutive month production date...if that makes sense!?!? Any...

Hi every one, I have a large database with 10 years of data I want to extract monthly data from it but the problem is that my monthly period starts at 9th of every month and ends at 8th of next month . I want to have a column that shows which month is the line in (my custom month) how can I do...

Dear all, I am working on the overlapping working time period, I manage to find out the number of days, months periods of overlapping but I need some help for identify the exactly those period,eliminate them and automatically replace with the the new date after that overlapping periods. The...

Hi, I have a huge data and multiple worksheets and need to consolidate into 1 "Summary" worksheet. Below are the steps I am doing.. 1. add new Column in "Summary" - "July-17"　 2. vlookup new number for the new month from ALL the worksheets　 3. If there is new customer in any worksheet, add...