Finding the lowest value

[broncos347]

I have a spreadsheet where Column A holds a document reference number, Column J holds a type (fixed rent/insurance/service charge), Column K holds a status (invoiced/to be invoiced), Column L holds a target date, Column M holds a target amount.

What I would like to report on, is for each reference number in Column A I would like to find the first value from Column M and where the status in Column K is "to be invoiced",


What I would like to show is for each reference number (from Column A) the first value (from Column M) where the status (from Column K) is "to be invoiced" and again where there is a change in value in Column M for each reference number.