I have a array of numbers set up I need to find the "last" time a particular
number shows up. i.e. the last time that part number sold. Column A
contains the week number. The cells in columns B to G contain the part
numbers that sold that week. What I need is if in week 32 was the last time
part number 2356 sold. I need a function that will return the 32 with out
looking through the list manually.