Get the max value of a column given the current date (this is hard!!!)

  • Thread starter Thread starter Shadow_Otixz
  • Start date Start date
S

Shadow_Otixz

Given:

a1: current date (ex: November 2, 2004)
b2: 11/1/04
c2: 11/2/04
C3: 1
C4: 2

a2: Reject Definition
a3: stain
a4: dent

How can I have the max value of a column having the current date and
have its reject definition? Let's say I want to place the max value a
b8 and its
reject definition at a8...

please anyone help me on this! this work is really making me crazy!
need a
computer wiz to get this work out!!!!

waaah!!!
 
Hi

okay if your spreadsheet is set up so that the first date is in B2, the next
in C2 then D2 etc
and in A3 to A7 you have the reasons and in B3:B7 the number of events for
the date in B2, etc then the following formula will get you the maximum for
each day and the reason

in B8 type
=MAX(B3:B7)
and fill across for each day

in B9 type
=LOOKUP(B8,B3:B7,$A$3:$A$7)

and fill across for each day.

hope this helps
Regards
JulieD
 
Back
Top