Formula to return Yes/No if it finds negative with data set,

Hi All,

I have an employee data set with staff numbers, names, pay periods and in the last column a change in pay (if any), positive or negative.

The date set for each employee has 61 lines (always 61), however I'm only looking to check the most recent 26 rows for each (always the top 26) for a negative value, i.e. a reduction. If it finds one then return Yes, else No etc

I'm using Index/Match elsewhere in the sheet, any I'm thinking there could be a variation of that but I'm unsure!

I've attached an example with the last 26 highlighted in yellow for 3 employees, would anyone have an idea for a formula?

Any help is appreciated.

Thanks

Dave

ddNegatives in last 26 weeks.xlsx

Hi Tony,

Thanks for responding, and apologies I highlighted 27 rows. The solution looks excellent however I'm not 100% sure I've implemented it correctly.

I have my dataset arranged diffrently, would you mind checking the attached sample?

Thanks

DavidNegatives in last 26 weeks 2.xlsx

Thats great Tony, thanks for the solution and confirmation. It looks like that will work perfectly.

Thanks

David

Wow!! What time in the morning is it for you, Biff?

Pete