Convert Formula in to VBA

[Motilulla]

Using Excel 2010

Hello,

Please I want help to convert Column R formula into VBA which can live the result in the value only once it run....because I need it must work with large data 50000+ rows.

Please see the attached workbook with examples.

Regards,
Moti

[JohnTopley]

Please Login or Register  to view this content.

output in AJ

[Motilulla]

output in AJ

@JohnTopley, thank you so much for your kind help your solution is very smart.

God Luck!

My Best Regards,
Moti