Hi,

So, I'm trying to count the number of non-zero values in a row, list the column of the first non-zero value, list the column of the last non-zero value, and list the counted sets as either a string or an array. Here's an example of what I'd like to do

A B C D E F G H I J K
1 NAME WK1 WK2 WK3 WK4 WK5 WK6 WK7 FIRST LAST COUNTS
2 JERRY 0 0 2 2 0 0 0 WK3 WK4 [2]
3 BOB 0 1 2 2 0 0 1 WK2 WK7 [3,1]

In all, I've got 55 weeks, and 65 people to analyze. Any thoughts on how to do this?