Dear All,
I have attached a excel sheet to depict what i plan to achieve. Planning to build the Thermometer graph based on the date selected by the user. Hence, it involves dynamic calculation of the data and require your support in building the formula.
Can this be achieved by using Array...
Dear Hui,
Thanks for posting the message.
I was going through www.exceluser.com and came across 'Array' function. Implemented the same to my current situation and it worked, and is a lot more simpler than i thought. Atleast a step that i was looking for has been simplified.
With regard to the...
Dear All,
On a weekly basis (on every 1st day of the week) i share the project status (No. of work orders delivered) to my Manager.
The data that is contained is
Header: WRNo.|Estimation|Planned Delivery date|Actual Delivery date|Status|Remarks
1stRow: XYZ |10 |25/01/2010...