Menu

Detecting abnormal values in a moving range.

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

Detecting abnormal values in a moving range.

homework?

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
I need to detect isolated potentially abnormal values
in a moving range of sequential data and write them in a separate
worksheet.
For example :

Day# 1 2 3 4 5 6 7 8 9 10 11 12 13
14 15 16 17 18

Value x x y x x y y x y y y y
z z y y y y

This problem requires the control of 2 moving ranges, 5 days and 10
days.

Rules :
1. The 2 days preceding values and the 2 days following values
are equal to each other but different from the current value
Write data to separate worksheet table under columns Day# and Value

Case Day 3 : Value "y" is an isolated potentially abnormal value.
Case Day 8 : value "x" ' ' ' ' ' '

2. A cluster of 2 equal values are preceded and followed by 4 days of
values
equal to each other but different from the cluster values.
Case Day 13 & 14 : value "z" are isolated potentially abnormal
values.

Expected table :

Day# Value RangeSpan
3 y 5
8 x 5
13 z 10
14 z 10

Help appreciated.

Wayne.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Averaging a Moving Range of values	dhstein	Excel Discussion (Misc queries)	5	April 14th 09 06:15 PM
detecting range of spreadsheet	altein	New Users to Excel	1	February 22nd 08 11:28 PM
Page display is abnormal	Arden	Excel Discussion (Misc queries)	6	January 23rd 08 01:49 AM
detecting data in a range	cjsmith22	Excel Programming	3	November 5th 05 12:23 AM
Detecting if a range contains a shape	Nick Hebb	Excel Programming	3	October 28th 05 02:45 AM

All times are GMT +1. The time now is 04:02 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement