Finding the lowest value in an array where the values starts in an acsending order.

**lifeankit** · 11-29-2013, 02:21 AM

Hi

I have an array of numeric values where the values are increasing and decreasing for like 30 values and then starts continuously increasing to a peak value.
I want to find the lowest value where the data starts increasing.

For example,
1 , 2 , 4 , 2 , 3 , 5 , 3 , 2 ,3 , 4 , 5 , 6 , 7 , 8 .

In above series the data starts increasing at value 2 in red color. So the code should give the element No.(element #) in the array of this value.

I am also attaching a sample of the data I am working with.

Thanks in advance.

**Decar** · 11-29-2013, 02:50 AM

the Problem I have with answering your question is to determine the exact point of time a data point counts as "no". Is there only one "NO" in the whole column? Or is it the lowest point when 6 numbers will be higher afterwards etc.

Because at the moment it looks like an IF formula =IF(Min(A:A),"NO",""). Otherwise how do I know that the 2 between the 4 and 3 should not be read?

**patel45** · 11-29-2013, 02:59 AM

Please Login or Register  to view this content.

**lifeankit** · 11-29-2013, 03:01 AM

Thanks for quick reply Decar. I am sorry I will edit my post as it gives a wrong interpretation - it is element No.(element #) instead of " NO".

The 2 between 4 and 3 should not be read as the values after that are not increasing continuously. The series goes to 5 and then fall back to 3.
And after the value 2 in red, the values are continuously increasing (3,4,5,6,7,8).

**lifeankit** · 11-29-2013, 03:14 AM

Thanks @patel45. It worked perfectly fine.

Thanks alot.

Finding the lowest value in an array where the values starts in an acsending order.

LinkBack

Thread Tools

Rate This Thread

Display

Finding the lowest value in an array where the values starts in an acsending order.

Re: Finding the lowest value in an array where the values starts in an acsending order.

Re: Finding the lowest value in an array where the values starts in an acsending order.

Re: Finding the lowest value in an array where the values starts in an acsending order.

Re: Finding the lowest value in an array where the values starts in an acsending order.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Finding lowest x values in a filtered column

Finding the Lowest Values and Matching

Formatting Data from one sheet to another to appear in acsending date order

Finding the sum of a row - the lowest 3 values

Finding the 5 lowest values in a range?

Bookmarks

Bookmarks

Posting Permissions