arrays

[squeekee35]

I have some data. it's a column of rpm cycles ranging from 3500 to 5500. i want to sort this data out in to peaks and vallies. and none of the peaks or vallies are the same value. i want to make one column for peaks and another one for vallies. i am trying to use the min max formula in an array style but it's not working.

i am using ={max(A:A,5200)} hopeing to get column B populated with all the numbers higher than 5200. i tried clicking control shift enter both all together and then seperatly but it's still not working.

I am not really familiar with arrays could someone please help me on this.

thankyou
angel

[MarvinP]

Hi squeekee35,

See if the attached helps with your problem. I'm not sure I understand the question.

[squeekee35]

that is not exactly what i am looking for. i want the column for peaks to list out the value of every peak and the column for valley to list out the value of every valley. i need to crunch this data and do a comparison between peak values and valley values.

[shg]

Post a workbook with your data ...

[squeekee35]

okay i sort of got it to work but it's not working as intended. it just gives me an array with only one max value. i need all the max values.

[squeekee35]

well i could not get the whole file uploaded so i just copied some of the data into a new file.

[tom1977]

look at attachment
list of numbers higher then 5200

regards

[squeekee35]

thanx. that works....but could you explain to me how...also how did you get it not to display empty cells in your array.

[shg]

You could put this formula in B2 and copy down:

=IF(A2=MAX(A1:A3), "max", IF(A2=MIN(A1:A3), "min", ""))

[tom1977]

I am not good in explanations but You can always use tool which is call “Excel Formula Evaluator” and see my formula