Hi Experts!
please help!
kindly refer to my attached picture for easy reference.
in the cell D, i want to formulate such a way that they can detect the duration in Cell C and auto detect the category.
for example, cell C2 is 1 year 10 months, so, at cell D2 it should reflect ">1 yr to ≤ 2 yrs".
thanks!