I've tried both formulas, all they give me is 0.
I've tried the IF function alone when there is only one occurence of 2356 in
the array B1:G52 and all I get is a false unless the I put the formula in the
same row as the occurence of 2356. Then it returns the vaule in the A1:A52
just like its susposed to. Could it be my version can't do ranges in the IF
function??? I'm using excel 2000 9.0.8961 SP-3.

"Alan Beban" wrote:

Assuming you have only one years's data (i.e., 52 weeks), should be
=MAX(IF(B$1:G$52=2356,$A$1:$A$52)

Perhaps better still

=MAX(IF(B$1:G$52=H1,$A$1:$A$52)

with the part number in H1.

Alan Beban

- wrote:
=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.