There are many ways to present the same information visually, some are better than others The best way to find out (and improve your Excel expertise) ...
You have the tools, use them wisely to complete the job If you need any advice on a particular issue, I am happy to help with that, but I cannot se...
Hi, there is a Camera tool that you can add to the Quick Access Toolbar (it's called "Camera") - to add, click the dropdown arrow at the end of the...
Hi Cristina, to show items with no data, you need to right-click the one of the row headings (ie N/A) and select Field settings, then the Layout an...
Hi Atif, did you just try to add that formula to your original workbook? My solution relies on having the additional helper sheet and various ot...
Hi Lakshmipathi, After you've added a standard Doughnut chart (via the Insert, Charts part of the Ribbon), you need to add Data Labels and select t...
tried to edit my post but Miguel cut me off! updated post here, and this time WITH an attached file! Hi Atif, maybe not the most elegant of ...
Hi Atif, maybe not the most elegant of solutions, but I've managed to find a solution without VBA sometimes we use helper columns to achieve our...
Hi Diogo, Not quite sure what you're trying to achieve here From your description on Sheet-1 it sounds like all you're going to do is replicate She...
Hi Garry, If you're on 365, then you can use XLOOKUP (formula for cell H3 in your pictured example) : =XLOOKUP(G3,$B$45:$B$49,$C$45:$C$49) (t...
Hi Ali, I assume you want the depreciation data to continue to the end of the year If so, then only one formula needed: clear cells F3:Q5 and ty...
I found Ismael's post and the linked source article by Mourad Louha which laid out the logic behind it and, now that I understand it a little better, ...
Thanks Mynda, I knew there would be a straightforward answer 😉 This only seems to work if there are the same number of entries in each list an...
Hi Riste, If your cell might also have a date component and you only wish to check that the time part is before 6am then you could use: =--(ISNU...