Formula

Cell I3 formula , Drag down

Formula:

Please Login or Register  to view this content.

Hi Sir wk9128,

Thank you this formula worked for me.

But i am noticing a little issue. When i dragged the formula up to four cells from I3 to I7, My File just got hanged for up to 10 seconds. I have to use this formula for file where there are 5000+ rows. So, it would create a lot difficulty. Can you please create a formula with less load on PC.

Hi dosydos,

Thank you so much for this formula. It worked very smoothly with not too much load on my PC.


Really thankful to you

@aslam5420 You're Welcome. Glad to help . Thank You for the feedback
Yes, you can narrow it down

Formula:

Please Login or Register  to view this content.

Hi Sir wk9128

Thank you so much for this, It now worked fine

@aslam5420 You're Welcome. Glad to help . Thank You for the feedback and rep.