Finding range of Cells containing low (range) values....

[kickme]

Hi,

I have data in a colum in which a particular range of data is significantly low as compared to rest of data. Data is varying and hence no fixed value can be ascertained to identify these cell. How I can find these range of cells ---Using a formula or macro.

Start row of Data is fixed but end row varies....Hence input range is not fixed..

Thanks

[patel45]

provide please a sample

[kickme]

provide please a sample

Sample.xlsx

Attach is the sample data.....
Data Starts from Row No 12
Low value data is in range of Row no. 868 to 927. Rest of data is significantly high as compared to to data in this range. Data Starts at row no 12 ...end is different each time...Low data range width and position will also vary...

Hope this explains the cituation...

[patel45]

You have to specify what significantly means for you, vba doesn't know this word

[StephenR]

Low value data is in range of Row no. 868 to 927

How so? How are you defining "significantly low"?

[kickme]

Average of low value is less than 50% than average of high value...i.e. what I call significantly low....