So Ali do the same for me, thanks …
If a helper can't ask any question, this forum may die !
jariszek,
I can't find a direct formula evaluation like in my first demonstration (Edit : Jindon did it, well done !)
but as I yet wrote it can be done just using a formula in column B for example
- as a helper column so temporary, can be cleared at the end of the VBA procedure -
so I though you at least give it a try as the formula seems not difficult
- formula returns column A value for data needed to be in the result array and FALSE for data to exclude -
and at moderator level so Ali may find a better worsheet formula than the formula array I'm thinking of …
So before any formula way, according to your attachment with so few data
the classic VBA looping arrays way well does the job :
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
Bookmarks