Forum

SunnyKow said Hi Sheikh This is as close as I can get to what you wanted. It uses an ARRAY formula so you must finish with CTRL+SHIFT+ENTER instead...

SunnyKow said Hi Sheikh Misbah Please attach a sample file containing your original data (without your formulas) and then the expected result (highl...