Thread: MAX figure within a date range as a function of today()'s date
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default MAX figure within a date range as a function of today()'s date
Oops, correction ..
Then in say, E2:
=INDEX(A2:A1000,MATCH(D2,C2:C1000,0))

Put instead in E2, array-entered (CTRL+SHIFT+ENTER):
=INDEX(A2:A1000,MATCH(D2,IF(B2:B1000="M",C2:C1000) ,0))
to return the corresponding name from col A

And if the weight loss in col C is expressed as negative numbers
just change the array formula in D2 to:
=MIN(IF(B2:B1000="M",C2:C1000))
(Use the same formula for E2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote