Hi Excel Ninjas
I required help to find the ageing bucket (0- 5 days .6-15 days .16-30 days .30 + days ) from the below different strings ... Kindly help on formula for this
Strings Ageing Bucket
---------------------------------------------------------
Rejected - 10 Days 6-10 Days
NoRelationship - 111 Days 30+ Days
NoRelationship - 8 Days 6-10 Days
Rejected - 56 Days
Rejected - 74 Days
NoRelationship - 0 Days
NoRelationship - 6 Days
Rejected - 74 Days
Completed - 2 Days
Rejected - 10 Days
NoRelationship - 2 Days
NotStarted - 3 Days
NotStarted - 3 Days
-
Bookmarks