Ian Bell
asked on
modify match formula by converting zeros
Hi,
I would like the attached formula modified to convert any zeros to 5
please refer to attached worksheet.
Thanks Ian
Match.xlsx
I would like the attached formula modified to convert any zeros to 5
please refer to attached worksheet.
Thanks Ian
Match.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Neeraj it works perfectly.
Your dashing and debonair Omar Sharif lookalike pic prompted me to smarten up my avatar.
Thanks for the compliment and flattery will get you everywhere :)
Your dashing and debonair Omar Sharif lookalike pic prompted me to smarten up my avatar.
Thanks for the compliment and flattery will get you everywhere :)
You're welcome Ian! Glad it worked as desired.
Thanks! Pleasure was all mine. :)
Thanks! Pleasure was all mine. :)
Open in new window