On Feb 10, 11:06*pm, wrote:
Hi all - I have the following columns and data
My Column headers are Item Code - Item Description and then Week
numbers for the year
The amount of sales for each item are scattered under the week number
- there are some empty cells and some cells contain 0

Sorry - didn't finish - so what I want to do is enter a column before
the weeks start and in the column pull the column header (week number)
for the last cell in the row that is greater than 0 - so if for item
"A" the last sales (number greater than 0) is in column G I want to
return the value in row 1 of that column - which would be the week
number Thanks - Jake