Help with conditional formula / extraction

[AjaySetty]

Hello Masters,

I have the below data set example where C is the resulting output I need, out of the A & B column i want to select data which has values into C.

Please help.

A	B	C
R	2015-10070	2015-10070
2013-10049	D	2013-10049
A	2018-00261	2018-00261
2018-00113	F	2018-00113
2019-00118	J	2019-00118
A	2012-10014	2012-10014

[atcodedog05]

Ok i understand now when Min() used on only numbers then finds min considering the whole number.

But if it used on chars then it works like a sort order and return first occurring

This is amazing 😎 who knew Min() was built for chars too. I had thought it would give a datatype error😅

Thanks for the explanation and this new learning @MarqueeCrew 🙂