Hi Mynda, If there is no Power Pivot, can I use the function of "Connections" to consolidate the several table into a single table? What are their...
Hi Mynda, It is helpful, I need time to learn more. My Excel 2016 has Pivot tables as well. So I would compare which way would be better to run...
Hi Mynda, My legtop is Microsoft Office Home and Business 2016. Thanks, Lucy
Hi Sunny, Thanks for your sharing, it almost looks like what I want I can calculate how many days pass in this month with the formula as: =DAY(T...
Hi Mynda, It is Excel 2016, Window 7 Professional. The stupid way I can only do now is copy and paste as value the PT to another sheet in the sa...
Hi Mynda, Sorry about that. Now I attach the file to you. Thank you very much, Lucy
Hi Mynda, The "PT" sheet in the attachment is the sample I want to have. Just want to know how to use the 2 sheets combine into 1 PT, and the day ...
Hi Sunny, It is very helpful! Thank you very much!!! Have a good day, Lucy