Hi All,
Is there any way to make the New Office 365 Filter Function to work by rows matching to an existing Spill Array ?
What I am trying to do is
e.g.
=FILTER(Source_range,Lookup_Colum=A2#,"NotAvailable")
Any help is appreciated
Hi All,
Is there any way to make the New Office 365 Filter Function to work by rows matching to an existing Spill Array ?
What I am trying to do is
e.g.
=FILTER(Source_range,Lookup_Colum=A2#,"NotAvailable")
Any help is appreciated
Last edited by ibuhary; 10-24-2020 at 01:19 PM.
If you mean you want all rows in Source_range for which the corresponding value in Lookup_Column has a match in A2#, try
=FILTER(Source_range,COUNTIF(A2#,Lookup_Column),"NotAvailable")
I tried your solution and doesn't seem to give the correct output.
Here is a public link for the file with some test data:https://1drv.ms/x/s!AOxmQ6JIaV-cgjs
Attach the workbook here, please. Instructions are at the top of the page.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
In what way isn't the formula working?
It looks to be working correctly, as it shows the rows for the 1st 2 values in col C & the last 2 don't exist.
Yes, correct. I was looking at the order of Items in Column C, rather its taking the order of the LookUp Sheet.
Sorry for the confusion.
Thank you for pointing it out.
I am unable to mark this thread as Solved !
Edit your opening post and choose solved from the drop-down selector.
If you want to sort the data based on col C, try
=LET(Fltr,FILTER(STOCK_EAN!$A2:$G5334,COUNTIF(C4#,STOCK_EAN!$G2:$G5334),"Not Available"),SORTBY(Fltr,MATCH(INDEX(Fltr,,7),C4#,0)))
We could do it before using thread tools, that was an easy option !
Thanks @Fluff13
That was awesome ! Thank you again for going the extra mile : )
Appreciate that.
Hi @AliGW,
Thank you for your reply.
My Apologies about the Attachment, unfortunately I don't have access to a file in any Local Drive to attach.
That's the reason I used the file in the cloud. Since there is a huge shift globally towards online drives, isn't it a good idea to allow users an alternate option ? Also it will reduce duplicate storage.
BR,
No. The point about this forum is that it is a database of help. It’s not just about solving your issue today: it’s about having the relevant materials here in the future fir anyone else who finds this thread useful. Your sample file won’t be there if you’ve moved it, but it would still be here. Next time, please do as I have asked. Thank you.
Okay, I understand.
But at the moment I don't have access to a Local Drive to manage attachments.
Let me try to do it as soon as I have access to one.
Thank you,
BR.
It's not hard to download the file in question to your PC and upload it from there ...
Attachment Done.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks