Show last payment on worksheet by finding first negative number.

[USAMax]

I am monitoring several accounts all with the header on row 10. In cell 7B I want to show the last payment in column E starting at row 11.

Once I know the row I will get the date from column A to put into cell 7C.

OFFSET has been working great for me and MAX has worked for most accounts but some accounts we have up to 50 transactions and others only a few. Here is what I have been using for some accounts.

=MAX(OFFSET($D$10,1,0):OFFSET($D$10,11,0))

 

[Fluff]

You can use this to get the date in col A for the last row in E

=LOOKUP(2,1/(E11:E10000<>""),A11:A10000)

 

[Peter_SSs]

Your written description and MAX(OFFSET formula seem to have nothing to do with your thread title which is to show "last payment on worksheet by finding first negative number".
If @Fluff's formula does not do what you want, please give some realistic sample data and the expected results with XL2BB and explain again in relation to the specific sample data.

 

[USAMax]

You can use this to get the date in col A for the last row in E

=LOOKUP(2,1/(E11:E10000<>""),A11:A10000)

Excellent, thank you. That worked.

 

[Fluff]

Glad we could help & thanks for the feedback.