View Single Post
 
Old 01-11-2021, 04:25 AM
arnoldg arnoldg is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2021
Posts: 3
arnoldg is on a distinguished road
Default

found a solution on Excel formula: Extract all partial matches | Exceljet

i myself optimised the formule to the one below

=ALS((RIJ(B12)-11)>ct;"";INDEX(data;AGGREGAAT(15;6;(RIJ(data)-11)/ISGETAL(VIND.SPEC(zoek;data));(RIJ(B12)-11))))
Reply With Quote