help with formula

[Hussein_Mohamed]

Dears,

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.

[#2]

@Hussein_Mohamed 

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

[#3]

could you please assest even with VBA instead of formula and thanks in advance

[#4 · Accepted solution]

@Hussein_Mohamed 

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)

[#5]

Thank You very much for your usual support