Searching and returning row number of a value

M

MikeDH

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.
 
R

Robert_Steel

=MATCH(1,B3:B33,0)

Should do what I think you need

I have assumed data is as follows

TITLE
Product ref #12345


hth RES
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top