CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaoffsetgoogle-sheets-query
For Memo
For Memo

Reputation: 31

How do I reference a range of a non-cell range in Google Sheets?

Example link

I want to reference a part of an array or a range that is not a cell range reference. Apparently OFFSET() only works with cell references. What function do I need to reference a range of a "created" range?

Upvotes: 1

Views: 28

Answers (1)

player0
player0

Reputation: 1

in your case you need:

=QUERY(B6:D9, "select D where C = 'MAN' limit 3")

enter image description here

but offset can be done even in query:

=QUERY(B6:D9, "offset 2")

Upvotes: 1

Related Questions