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.
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!
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
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.
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
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.
Thank you. That is very kind of you to say 😁.
I’m just trying to help us all automate our work through good practices.
I couldn’t agree more. Excellent and creative as always!
Thank you. The process/framework is great for lots of different charts.
Phantastik!
You're welcome.
Great video Mark. It's packed with info!
Thanks Victor 😁
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!
That is very true - good point.
Excellent and straight to the point, Thank you
Thank you. I'm glad it was easy to follow.
Great great video Mark. Excellent explanation. Thank you for sharing!
Thanks Ivan. Glad it was helpful. 😁
Wizardry ! Amazing work. Thanks for sharing 👍💥
You're welcome 👍
Excellent and creative as always. Thanks Mark👍❤🌹
Thanks Kebin 😁
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
You mentioned your use of a data table twice in this video, Mark but I didn’t see how you did that.
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.
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