Using IF AND to filter number in a range, works with dragging, but not in an Array

		Microsoft Office Forums > Microsoft Excel > Excel
Using IF AND to filter number in a range, works with dragging, but not in an Array

FAQ

Thread Tools

Display Modes

11-17-2022, 07:58 AM

Pecoflyer

Windows 10 Using IF AND to filter number in a range, works with dragging, but not in an Array

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

What do you mean by Excel (Google Sheets) ?
"Arrayformula" is not an Excel function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Loading an Excel range to an array in VBS	BobBridges	Excel Programming	1	12-25-2020 01:04 PM
Filter range	marif300	Project	3	05-05-2017 02:39 PM
Error: AGGREGATE_doesn't ignore hidden rows for particualr array range	adisco	Excel	1	01-10-2017 10:59 AM
Filter by a Month that falls within a date range	MattG1225	Excel	2	12-03-2015 07:44 AM
Range Name in Adv Filter -> NOt working	56_kruiser	Excel	2	11-20-2012 09:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:55 PM.