Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2021, 11:28 PM
arnoldg arnoldg is offline formula not working in excel 2016 Windows 10 formula not working in excel 2016 Office 2016
Novice
formula not working in excel 2016
 
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
  #2  
Old 01-11-2021, 02:27 AM
Purfleet Purfleet is offline formula not working in excel 2016 Windows 10 formula not working in excel 2016 Office 2019
Competent Performer
 
Join Date: Jun 2020
Location: Essex
Posts: 229
Purfleet is a name known to allPurfleet is a name known to allPurfleet is a name known to allPurfleet is a name known to allPurfleet is a name known to allPurfleet is a name known to all
Default

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?
Reply With Quote
  #3  
Old 01-11-2021, 02:33 AM
arnoldg arnoldg is offline formula not working in excel 2016 Windows 10 formula not working in excel 2016 Office 2016
Novice
formula not working in excel 2016
 
Join Date: Jan 2021
Posts: 3
arnoldg is on a distinguished road
Default

In the attachment my project.

on the second sheet, there is the formula which isn't working.
Attached Files
File Type: xlsm Klanten database.xlsm (45.8 KB, 1 views)
Reply With Quote
  #4  
Old 01-11-2021, 04:25 AM
arnoldg arnoldg is offline formula not working in excel 2016 Windows 10 formula not working in excel 2016 Office 2016
Novice
formula not working in excel 2016
 
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
Reply

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 excel 2016 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft