I would consider using a Pivot Table.
Hi Bob See if this helps Sunny
Hi Elinor You can refer to my example attached as a starting point. The formula is very complicated and crazy but it should work (provided your dat...
Hi John See attachment. I have created 4 tables and gave each a name as per your plant type. I then use the INDIRECT function to refer to the...
Hi Andy As James said above, it is best if you can rearrange your data properly. Otherwise the formulas can get very messy (as per attachment). ...
Hi Irfan To get the effects you see on your image, you will need to create "transparent" charts. (transparent chart area and plot area) Most of ...
Hi Lucy I have included many notes in the worksheet itself to explain what I am doing. Q1. How did you combine the sheets of "actual sales" and ...
Hi Lucy You can also try using PivotTable as per attached. Not too sure how you calculate the Day Pass % but my guess is today's date less end o...
Hi Philip What you requested is very tricky to handle and need to take into consideration many scenarios. It is not fool-proof. Saving password ...
Hi Lucy You can take a look at the attachment. It uses array formulas. You can read about array formulas here You may have to modify the range...
Hi Aleksandrs I used the data from the CSV file and not from your worksheet to do the text-to-column. Excel already recognize them as dates as m...
Hi Jeff I would suggest you just use Excel to do what you want as it is easier. Click Home > Find & Select > Find, and a Find and Re...
Hi Aleksandrs When you reach the third step of text-to-column, select the column with the date. Under Column data format, click on Date and sele...
Hi Julian Maybe you can give this a try. Range("A1") = Application.Evaluate("upperbound") Sunny
Hi Hava Q1 - One way is to copy and paste the format to 1 chart. Then select all other charts individually and press the F4 function key to repeat ...