Now, theres an open-ended question, if ever there was 1? (how long is a piece of string? I hear you say?)
Im sure we have all - at 1 point or another - been asked how we go about solving an excel problem, and have probably offered some advice on this?
I thought it might be of use to have a thread devoted to just this question, and have members share their approaches? (maybe even make it a sticky?)
This was my attempt on a thread I was answering...
My approach is to determine which pieces of info I need to resolve the question.
Then I (try and) figure out how to get each of those pieces of the puzzle (that is often the hard part)
I then fit each of the peices together into 1 formula - and then test
I guess what it comes down to is that you generally need two things (at least) to run a calc, but often, those 2 (or more) things are not inthe same format/context, so you need to convert 1 or the other - or sometimes both - to something similar that you can then compare or add or whatever.
Once I combined the 3 pieces of info on sheet 1, that gave me a starting point
There is no 1 standard 1-way-fits-all approach for this (at least, I dont thing so)
Thoughts???
Bookmarks