Microsoft Office Forums - View Single Post - [Solved] formula not working in excel 2016

Thread: [Solved] formula not working in excel 2016

View Single Post

Old

01-10-2021, 11:28 PM

arnoldg

arnoldg is offline

arnoldg uses Windows 10

Windows 10 arnoldg uses Office 2016

arnoldg uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jan 2021

Posts: 3

arnoldg is on a distinguished road

Default

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

Reply With Quote