Thread
: [Solved]
formula not working in excel 2016
View Single Post
01-11-2021, 04:25 AM
arnoldg
Windows 10
Office 2016
Novice
Join Date: Jan 2021
Posts: 3
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))))
arnoldg
View Public Profile
Find all posts by arnoldg