Consecutive Increasing Row Values Formula

Hi. I have been working on this problem for several days and I need help from people who are smarter than me.

I have a spreadsheet where up to 20 samples are entered manually into a table (D3:D22). I want to find the samples that are consecutively increasing that meet or exceed a consecutive data up value in A3. If the data meets this consecutive up row count value I want to display those data values and ignore all the others. I have attached a copy of the spreadsheet to help better illustrate what I am trying to do. There are two scenarios described within this spreadsheet attachment.

Thanks

Do you mean this?

=IF(F3+F4>1, D3, "")

Yes and no. I like that your formula is very simple and effective, however, it highlists sample numbers 5-9 OK but sample numbers 12-14 and 16-18 need to be skipped because they do not meet the Consecutive Data Up value in cell A3.

Sorry, didn't notice criteria...

Check now..

Hope you don't minde that I changed column F

Incredible. Works exactly as I want. What I have been working on for days you resolved in less than an hour.

Many, many thanks for your help with this problem.

hi zobr, how do i restrict to check for a customer only, col1 (customer), col2(date), col3(rev) i want the same thing as explained above but to check for last 12 increasing numbers for each customer,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.