Challenge - evaluate and select
Here's an interesting one.
Suspect it might require VBA, but it'll be more than just VBA.
Let's say I have a figure that one system has spat out, but it's not clear
how it's been arrived at.
Another system might give a list of all possible components to this in a
report which can be exported to Excel.
I would want a tool to look through the list of all possible values and
select only values which could be combined to make up the total that the
other system spat out.
Does this make sense?
Is it something we could ever get a computer to do?
Thoughts?
|