help with formula

Brass Contributor


would it be possible for someone to kindly share the solution with me via excel formula. i need to complete an important project and would greatly appreciate your assistance.

thank you very much for your time and help.



4 Replies


You asked for a formula, but would a VBA solution be acceptable?

could you please assest even with VBA instead of formula and thanks in advance
best response confirmed by Hussein_Mohamed (Brass Contributor)


Here is a macro that you can run. See the attached workbook (it is now a macro-enabled workbook, so you'll have to allow macros)

Thank You very much for your usual support