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

mda99das Using IF AND to filter number... 11-17-2022, 07:50 AM

Pecoflyer What do you mean by Excel... 11-17-2022, 07:58 AM

mda99das Apologies, I thought google... 11-17-2022, 08:04 AM

Pecoflyer So what are you looking for,... 11-17-2022, 08:58 AM

mda99das Its the AND function in an... 11-17-2022, 01:12 PM

mda99das so the next part of the... 11-17-2022, 01:27 PM

11-17-2022, 07:50 AM

mda99das

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

Office 2013

Novice

Join Date: Oct 2022

Posts: 12

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

I have found a way in Excel (Google Sheets) that filters the ages from 5-9 inclusive. If they fit it , it returns YES otherwise NO

=IF(AND(L1>4, L1<10), "Yes", "No")

I have the ages in column L, and I drag this down to autofill and it works well.

I then used an array formula, that I have used to autofill the column as data is entered

=ArrayFormula( IF(ROW(L:L)=1,"Suitable?", IF(ISBLANK(L:L),"",IF(AND(L:L>4,L:L<10), "Yes", "No"))))

This returns NO all the time
Can someone guide me how to get this to work?

Many thanks

« 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 06:48 PM.