View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Using IF and MAX functions together

Good to hear that

I'd bet my last 2 cents that no responder could have
come up with the solution that you posted below,
based on your original posting <g
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 16,200, Files: 354, Subscribers: 53
xdemechanik
---
"Michelle" wrote in message
...
I just cracked it myself... very satisfying. I used:

=IF(GETPIVOTDATA("Extended Price",$A$3,"Product Name","Chicken burger low
fat frozen - mega pack")=MAX(B4:B11),"highest value"," ")
--
Michelle