Thursday, May 24, 2018

yogi_Find minimum value in range of duplicates

Google Spreadsheet   Post  #2449

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-24-2018

question by: Paul-Grant Van-Rooyen
https://productforums.google.com/forum/#!topic/docs/8iyQlLwxcxs;context-place=forum/docs

Find minimum value in range of dulicates

Hi there folk,

I am looking for a formula/query to run and find the minimum values in a range that contains duplicates (2 or more). 

The first range which is sorted is in A1:B14 with the required results in D1:E18 (formula required in Cell D2.

The first range which is sorted is in A19:B32 with the required results in D19:E26 (formula required in Cell D20.


Cheers