Excel: Find min/max values in a column among those matched from another column

by

It works for me.

for min:

=MIN(IF(($A$1:$A$50=D1),($B$1:$B$50)))

for max:

=MAX(IF(($A$1:$A$50=D1),($B$1:$B$50)))

Note, that it is an array formulas, so you need to press CTRL+SHIFT+ENTER

More Related Contents:

  1. Excel VBA – How to add dynamic array formula
  2. Difference between date and time w/out work week Excel
  3. Combine 2 Excel tables into one appending the data?
  4. Compare double in VBA precision problem
  5. Row count on the Filtered data
  6. Excel VBA Macro: User Defined Type Not Defined
  7. Automate IE via Excel to fill in a dropdown and continue
  8. Run-Time error 1004 Excel 2013
  9. VBA – Write all possible combinations of 4 columns of data [duplicate]
  10. Excel VBA to Export Selected Sheets to PDF
  11. Remove duplicates from array using VBA
  12. Controlling Internet Explorer local intranet using Excel VBA
  13. Count Unique values with a condition
  14. How to automatically insert a blank row after a group of data
  15. Get File Path (ends with folder)
  16. Get length of array?
  17. Email a single attachment from folder of files each to a different person
  18. Bad data selection using VBScript , on date field values
  19. How to list all possible combinations of the values in three columns in excel?
  20. Sending object array to variant works before August 2019 Windows update, but fails after update
  21. Find last row in range
  22. Differences between Excel’s Form Controls & ActiveX Controls
  23. Excel VBA User Defined Function that counts cells with conditional formatting
  24. MS Excel – Concat with a delimiter
  25. Excel is calculating a formula with a VBA function as an error unless it is re-entered
  26. Delay macro to allow events to finish
  27. Export multiple sheets to PDF simultaneously without using ActiveSheet or Select
  28. declaring a unicode string in vba in excel [duplicate]
  29. Delete all data rows from an Excel table (apart from the first)
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment