My main worry is that everything I am doing is inside Excel's addon called BW (Business Warehouse). This have some many disadvantages but inside those disadvantages also some advantages:

Disadvantages:

- with full respect to you, macropod and everything else (please do not take this as anyhow offensive statement): most of Excel specialists won't know what BW addon is and therefore might not even be willing to answer.

- if I, by wonder, manage to find someone very familiar with BW addon, my addon is so much customized/personalized, which I haven't done (customizing - programming, its NOT just own language), that it might get confused even BW expert. Extremly custom filters with extremly custom parameters, even custom buttons like Cancel, OK, Saving, Editing, Right Click menus, Windows, Add, Remove etc. Everything is changed and personalized.

- no idea how would be possible that tool I am searching for would access and analyze the parameters/values in CUSTOM windows, specially the ones Not used - they might still effect used data.

Advantages (!):

- entire BW is used inside Excel only so Excel rules should still work (general rules)

- if I knew how (but I don't so please tell me) I think I always have possibility to check whether or not filters, their parameters and values can be accessed and checked via regular Excel methods of checking/accessing filters. I am just worried that Excel won't be able to access the addon since it seems to be completely isolated (but still located and used only within Excel). However disadvantage of this advantage is actually third disadvantage said above starting with "no idea".

BobBridges yes I am searching tool that will do "everything versus everything else" analysis but, I apologize for correcting you, kindly note that defining WHAT to analyze might not save any time at all. Everything needs to be compared (i purposely used word 'compared' and not 'analyzed' so I can be understandable more) with everything else and, to answer your comment, every way of comparison has to be performed. Everything that might automatically report (obviously without me manually doing the charts) uncommon relations. So again, all/every possible analysis must be runned.

macropod regarding your comment:

"none can determine the results' relevance to you"

All I would choose is excel file and what is counted as Out Of Boundary. So what is counted as being Unacceptable which is what I want to have reported BUT this doesn't mean the tool I am looking for would compare just those filters related to the subject of what I would define. Everything needs to be included. Everything, even the parameters/values NOT used because they might still effect the ones used.

EXAMPLE:

I would just compare everything (all worksheets in one excel file - yes i know it would take long time processing) in progression levels similar to:

Step 1: Comparing every filter (BW's one inside Excel so custom one and not Excel's one) to every other one

Step 2: Comparing every single parameter in every filter with every single parameter in every other filter as well as same one (if chosen or not doesn't matter)

Step 3: Comparing every value in every parameter of ONE filter with every value in every parameter of the SAME filter

Step 4: Comparing every value in every parameter in other (all others) filters with every remaining values in every remaining parameters in other filters.

So briefly: Comparing everything with everything. Every value with every/any other one. So I would get out of ordinary (nonclassic/weird/unwanted) values (why is some value too high or too low) automatically. Of course I would need to define the boundaries - where is something still normal and where "out of ordinary". Or preferable way: I would have automatically shown something that is uncommon BASED ON other values.

ONE example (i could list millions but I will just one - ONLY example, im actually doing this for totally different, engineering, project for manufactory) what would I expect from such automated analysis:

If I have 5 filters:

- country
- age
- genre
- area of interest
- religion

With different parameters (***showing only two, for genre, area of interest, religion, it would be similar logic):

country: europe, asia, africa,
age: between 20 and 30, between 31 and 40, between 41 and 50

With values (*** see note above):

country: germany, france, england, scotland, italy, poland, japan, kuwait, nigeria, egypt
age: 20, 21, 22, 23, etc

actually I have many more values/parameters/filters in BW but its just example. Then the tool I am asking for would compare everything with everything else based on given boundaries/criterias that would be defined inside the tool/software/whatever im asking for/excel's addon/etc:
compare (named as vs): country vs. age, europe vs between 20 and 30, europe vs between 31 and 40, europe vs between 41 and 50, asia vs between 20 and 30,..., germany vs france, germany vs england germany vs scotland,..., france vs england, france vs scotland,..., germany vs 20, germany vs 21 and so on and so on. So everything with everything.
So in such way I could easily get info why is some filter varying so much, because of what is varying, what could be done (which parameter/value used) so it won't vary too much, where are values (e.g. expenses in particular country for particular age) too high and many many more.