Hello to all,
I'm trying to filter data from sheet "Registos" into sheet "Listagens".
In sheet "Listagens", cell B3 contains my formula based two criteria, cells C2 and F2.
The formula should return only one line but it is showing all records...
Can someone please give a hand on this?
Many thanks,
Octavio
Please replace 1 bracket and try:
Formula:
Please Login or Register to view this content.
One bracket is misplaced...
=FILTER(Registos!A2:G277,(Registos!$B$2:$B$277=C2)*(MONTH(Registos!$C$2:$C$277)=F2),"No data")
You'll need ; instead of , in Portugal.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I was too slow!! HD beat me to it...
Hello Glenn and Hans,
Thank You both for the help, but now it shows "No data"...
WAIT, my mistake, It working perfectly!!
Thanks a million
Octavio
LoL... we couldn't both have been wrong... You're welcome!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks