CODEWITHSUNDEEP
filtergoogle-sheetsspreadsheet
tr05t
tr05t

Reputation: 63

google spreadsheets FILTER multiple columns

I created a contact register with the following structure:

id + lastname + name + phone + mobile + adress + birthdate + ...

Now, I just want to filter for contacts which are having birthday in the next 7 days and show lastname, phone and birthdate...

So I tried this: (please ignore pseudocode in the conditions)

=FILTER({B:D, F:G}; DAYS([Birthdate];[TODAY()])>=0; 
              DAYS([Birthdate];[TODAY()])<=7)

I also tried this from a post in the Google Docs Help Forum , but I always get Error, Formula parse error..

When I separate the column with ; I get Error, FILTER has mismatched range sizes. Expected row count: 356. column count: 1. Actual row count: 178, column count: 1.

How can I concatenate the rages?

Upvotes: 1

Views: 5730

Answers (1)

Max Makhrov
Max Makhrov

Reputation: 18707

To simplify the case, I left just two columns enter image description here

The formula is:

=FILTER(A2:A,(TEXT(B2:B,"MM/DD/"&YEAR(TODAY()))*1>=today())*(TEXT(B2:B,"MM/DD/"&YEAR(TODAY()))*1<=TODAY()+7))

in some regions semicolon is used: ;

The formula for them is:

=FILTER(A2:A;(TEXT(B2:B;"MM/DD/"&YEAR(TODAY()))*1>=today())*(TEXT(B2:B;"MM/DD/"&YEAR(TODAY()))*1<=TODAY()+7))

Upvotes: 1

Related Questions