Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find anomalies in a list of data
I have a table of values for 5 different geographical areas. I want a formula
that will look at 4 of the areas and compare it to the value of the 5th. If any of the areas are totally different than all the other values (ie. an anomaly) it will return the name of the area A B 1 NI 12 2 South 37 3 Laganbank 9 4 Balmoral 18 5 Belfast 15 Therefore if we take Belfast as the comparator(B5), i want a formula that will search the list from NI-Balmoral (B1-B4) and it will return the name South (A2) as the value 37 (B2) is an anomaly. For this example we will look for any values B5+10 or < B5 -10. therefore any values that are not within the range 5-25. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find a data in a list that have a few hit | Excel Worksheet Functions | |||
How can I find data in one list and add it to another sheet? | Excel Worksheet Functions | |||
=countbycolor anomalies | Excel Worksheet Functions | |||
graph ignoring anomalies | Charts and Charting in Excel | |||
Command Button anomalies | Excel Discussion (Misc queries) |