identifying first non-zero value in multiple rows

[Newport Count]

Hi,

I am trying to display data from several rows onto a single row - the first single row for that chunk of data.


Example (sorry about the format):

columnA columnB columnC columnD columnE
batch line item no. value desired outcome1 desired outcome2
35 1 0 55 15
35 2 55
35 3 15

57 1 0 12.5
57 2 0
57 3 12.5

88 1 0 blank

91 1 0 blank


Batches are listed in a spreadsheet in numeric order and a blank row exists between each one, where no data exists.

Potentially, each data set (batch) could contain several line items....but only some have values.


Ideally, I would like to list these values in column D (and in column E, if more than one exist)


I can't work out how to search for a non-zero value and display it, and then also stop when a blank value (blank row that separates batches) is found.


Any ideas?


Cheers,
Rich

 

[Newport Count]

sorry that looks terrible - I can't work out how to add an image or spreadsheet

hope you can work it out