Hi Mark, Very well structured and clearly explained. (as always)👌👋 Useful in many ways (also to prepare other data) I am a fan of your videos and already have a membership to one of your courses. Thank you for the hard work and commitment to help us learn to use Excel in a professional way.
@ExcelOffTheGrid5 ай бұрын
Thank you. That is very kind of you to say 😁. I’m just trying to help us all automate our work through good practices.
@tibibara2 ай бұрын
Hi Mark, brilliant solutions, I'm impressed! Thanks a lot! 😇 Just one important thing to consider -> calculate event in case of auto calculate settings will kill our UNDO-CACHE every time when the sheet is calculated!
@ExcelOffTheGrid2 ай бұрын
That is very true - good point.
@IvanCortinas_ES4 ай бұрын
Great great video Mark. Excellent explanation. Thank you for sharing!
@ExcelOffTheGrid4 ай бұрын
Thanks Ivan. Glad it was helpful. 😁
@FernandodeCarvalhoNavarro24 күн бұрын
Phantastik!
@ExcelOffTheGrid24 күн бұрын
You're welcome.
@spen24315 ай бұрын
Wizardry ! Amazing work. Thanks for sharing 👍💥
@ExcelOffTheGrid5 ай бұрын
You're welcome 👍
@rus1ickoff5 ай бұрын
I couldn’t agree more. Excellent and creative as always!
@ExcelOffTheGrid5 ай бұрын
Thank you. The process/framework is great for lots of different charts.
@launchexcel5 ай бұрын
Great video Mark. It's packed with info!
@ExcelOffTheGrid5 ай бұрын
Thanks Victor 😁
@tahirhanif96695 ай бұрын
Excellent and straight to the point, Thank you
@ExcelOffTheGrid5 ай бұрын
Thank you. I'm glad it was easy to follow.
@francescox795 ай бұрын
Amazing 👏 🎉 At the moment im struggling with one task, maybe you can support me how to do. Task: Which two items are the most frequently used item. Consider the transaction code. Table 1: Column A: transaction Column B: item Column C: quantity Table 2: Column A: all possible combination of the items Column B: (result) how often the combination has been used. It would help me a lot, thanks in advance
@kebincui5 ай бұрын
Excellent and creative as always. Thanks Mark👍❤🌹
@ExcelOffTheGrid5 ай бұрын
Thanks Kebin 😁
@duncanwil5 ай бұрын
You mentioned your use of a data table twice in this video, Mark but I didn’t see how you did that.
@ExcelOffTheGrid5 ай бұрын
I put everything in a Table as it has automatic expansion for formula references. Select a cell in the data, then press Ctrl + T, or click Insert > Table.
@duncanwil5 ай бұрын
I thought that was the case ... so it's not a data table at all, which, as you know, is a special case in Excel. By the way, I have been a user of jitter plots for a few years now and I would respectfully suggest that the range you have set for the width of the jitters is a bit wide and I would probably use no more than half of the range you have set. Otherwise, they are a great addition to our world of visualisation,@@ExcelOffTheGrid