I'm using Excel to do data analysis of product testing results. Formatting
of test results is quite simple: in 'TasteResultsX' I have the lot numbers
from company X in row one. The next 30 rows countdown to 1 the days of
testing (day 30 results, day 29 etc.) with a 1 signifying a pass and 0
signifying fail. All I'm really interested is the row number of the first
instance of 1 (the last day on which the product passed); I'd like to pass
that value to 'X Results', where results of bio-tests have already been done.
Problem is, I haven't used Excel in enough detail to really know how to find
the match the lot numbers from the first row of 'TasteResultsX' to 'X
Results' and then - from that result - search down the corresponding column
of 'TasteResultsX' for the first instance of 1 and return the row number of
that instance to 'X Results'. If anyone could help me on that, you'd have my
infinite amount of gratitude for at least the next 3 weeks (how long I'd be
sitting trying to figure it out on my own). Thanks.