Thread: [Solved] Looking for formula
View Single Post
 
Old 11-27-2016, 08:38 AM
joeu2004 joeu2004 is offline Windows 7 32bit Office 2007
Advanced Beginner
  
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default
Array-enter (press ctrl+shift+Enter instead of just Enter) the following formulas:

=MAX(IF(A1:A100=C1,B1:B100))

=MIN(IF(A1:A100=C1,B1:B100))

where C1 contains the part "number" entered as the same type as the values in column A (text or numeric).
Reply With Quote