Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question