Forum

Notifications
Clear all

How do you find the second small figure?

2 Posts
2 Users
0 Reactions
60 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

Hi,
In the table here -
Each customer should get his first date from the data table,
I performed with the Minifs function
But there are customers that are written 01/01/1900 - this is not correct
And I need a function instead of Small - write another formula -
That you know how to pull out the customer's minimum date -
Which came immediately after 01/01/1900
Dodge customer number 12593 - should be accepted on 20/03/2016

Thank you very much for your help!!
Leah

 
Posted : 12/11/2021 1:03 am
(@debaser)
Posts: 836
Member Moderator
 

Couldn't you just add another criterion to the MINIFS that the date in B has to be >1?

 
Posted : 12/11/2021 6:35 am
Share: