#1
|
|||
|
|||
formula not working in excel 2016
Hello,
At home i have office 365, there a build a form with a formula. But this isn't working at work (Excel 2016). is there a same sort of function in excel 2016 for filter below is my formula =FILTER(Tabel1[obj_naam];ISGETAL(VIND.ALLES(B10;Tabel1[obj_naam]))) Last edited by arnoldg; 01-11-2021 at 04:26 AM. Reason: Added the solution |
#2
|
|||
|
|||
Filter isnt in excel 2016 - probably going to need some kind of array formula - can you attach an example workbook so we can see it in context?
|
#3
|
|||
|
|||
In the attachment my project.
on the second sheet, there is the formula which isn't working. |
#4
|
|||
|
|||
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)))) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
If & And formula not working | Haha88 | Excel | 3 | 02-17-2019 05:57 AM |
Formula not working in Word 2016 | evie073 | Word Tables | 1 | 11-28-2017 04:03 AM |
Directional help in constructing an Excel 2016 If, Or, And Then Formula Statement | Gwilson | Excel | 3 | 04-13-2017 11:31 AM |
microsoft excel 2016 has stopped working | ropipo | Office | 2 | 10-27-2016 10:38 PM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |