Search results

How are you getting on? If you need some help there are plenty of very good resources 'on the line'. I've not used this one but it looks well structured and crucially, it is free: https://excelexposure.com/ (this one is recommended on university of reddit, if that holds any sway)...

Wow. I did not know this shortcut. More please. In fact, any nice windows / office shortcuts please. NOTE: Points will be deducted for crap or obvious ones.

Not if you are the only one using common sense! :) Which is unfortunately why you need these standards, some of it really isn't immediately obvious. I prefer small companies as there is so much less red tape and defined process, obviously riskier but easier to remedy issues. That said, I've...

I love meeting like-minded saddos. We actually have an expedited process so that's the route we've gone down. It's an interesting* question as to whether it was an incident. It's just a report, but going into our ERP (SAP). It's already live, but doesn't work due to performance issues -...

I'm not sure if this is a genuine question. To be fair, I'm not sure any of them are, but there you go. You can't really depict anything meaningful on a pie chart, especially not things with completely different measurement criteria. You could represent your data in a stacked bar chart...

Highlight the cells in question, right click, choose format cells. Under the 'Alignment' tab you will see a box on the right called 'Orientation'... should be self-explanatory from there :)

Yep, I don't know how to do it in a single formula. Can try and work it out but it might be really complex, UDF is probably the best bet. Or another hidden column :) The value in A10 will be 229 - the sum of all innings where the batsman was not out (denoted by asterisk). Please note I may...

You can use sumif / countif to work with asterisks as long as there is never more than one in any given cell (Excel will only count 1 even if there are multiple in the cell). Use char(42) as the thing to search for rather than * as it makes the formula much simpler.

YES! I have a change I need to put in as an emergency, it's all tested and complete but I don't want to go through the tedious change management process as this adds extra delays due to change advisory board meetings etc. Please advise how I can best circumvent the red tape without getting...

PRS, please note you are a prime candidate for learning 'INDEX MATCH' rather than vlookup. MUCH better performance and not much more difficult to understand either. Check it out and report back :)