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.
https://docs.google.com/ spreadsheets/d/ 169Vewmpcwu5r3bbOT2Ich06a17naO UUuOuIPWMkDo4I/edit?usp= sharing
Cheers
No comments:
Post a Comment