View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mr tom mr tom is offline
external usenet poster
 
Posts: 119
Default 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?