Link to home
Start Free TrialLog in
Avatar of LUIS FREUND
LUIS FREUND

asked on

Latest date in Excel based on percentage

Wanted to get latest date from Column C based on percentage column B.

On the attachment, I wanted to get the latest date but if the percentage is greater than 50% than exclude that date.  Only get the latest date if it's less than 50%.
C--Users-lfreund-Desktop-LATEST-DAT.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LUIS FREUND
LUIS FREUND

ASKER

Thanks Gents!  Always a pleasure ....