Thread: [Solved] List max values in a range
View Single Post
 
Old 04-20-2017, 04:40 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Try this is array formula in D1:

=IF(C1=MAX(IF(($A$1:$A$8=A1)*($B$1:$B$8=B1),$C$1:$ C$8)),C1,0)

confirmed with CTRL+SHIFT+ENTER not just ENTER, then copied down
Reply With Quote