M
M
Maxim2018-09-12 02:28:31
Google Sheets
Maxim, 2018-09-12 02:28:31

How to find the first date in the range by condition and calculate how many days have passed?

Hello! There is a table.
DATE | NAME | VALUE
It contains data
09/12/2016 1:17:07 AM | IVAN | 12 |
02/24/2017 1:20:07 AM | IVAN | 50 |
06/01/2018 1:22:07 AM | MARGO | 20 |
03/26/2018 1:25:07 AM | IVAN | 30 |
May 22, 2018 1:26:07 AM | ARTEM | 10 |
I need to find the minimum date from column A (DATE) according to the condition from column B (Name).
For example = MINDATA (A2: A), where (B2: B = "IVAN"). In this case, the answer will be 09/12/2016 1:17:07 AM . After that, I will need to calculate how many days have passed from the minimum date to today.
Help with formula! I will be very grateful!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Aleksandr, 2018-09-12
@myks92

See the FILTER and SORT functions (a head-on solution, without any frills).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question