=MAX(IF(B$1:B$100=2356,$A$1:$A$100))

Array Entered (Ctrl + Shift + Enter)


"scidoc" wrote in message
...
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.