Dear Friends:
I have an array, dynamic. I want to remove from this array a list of values, which is available in another array.
While trying to do:
=FILTER(I2#,I2#<>K2#)
I got an error.
Where is my mistake. Thank you for your help.filter.jpg
Dear Friends:
I have an array, dynamic. I want to remove from this array a list of values, which is available in another array.
While trying to do:
=FILTER(I2#,I2#<>K2#)
I got an error.
Where is my mistake. Thank you for your help.filter.jpg
Voici:
=FILTER(I2#;(ISNUMBER(MATCH(I2#;K2#;0)))=FALSE)
Last edited by AliGW; 07-22-2023 at 05:54 AM. Reason: Workbook added.
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.
Please Login or Register to view this content.
It works! Thank you so much guys for this quick fix.
Hi Ali,
Please let me know if this deserves its own thread.
How would this work if the searched array had two columns? e.g. If you were filtering by a range of dates.
Parker
M2=filter(i2#,isna(match(i2#,k2#,0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks