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

Mark Forums Read

Thread Tools

Display Modes

11-17-2022, 08: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,948

Pecoflyer has a reputation beyond repute

So what are you looking for, an XL or a GS solution?
If XL please post a sample sheet ( no pics please)

__________________
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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 11:11 AM.