it works, but the excel file it becomes too slow when there are a lot bigger list than yours, so if ever you hava another solution I would be very grateful if you share it with us
Thnx Stephane! I did not try this method on much bigger lists. There are a lot of other methods to achieve something similar as this, especially with all the new functions in Excel nowadays. You can easily find them when googling on this subject. Maybe in the future I will make another video about this subject with other methods.
@@rbxexcelvideos I'm trying to find a solution within using VBA, for the moment there are 3 personnes plus you who proposed some solution and it's either too slow after or there are circulate reference error because of cell (adress or contents) formula used Thank you any way for your answer
My office doesn't have filter function, it has filter XML function
Hi Insomniac, that is probably because the FILTER function is only available in Office 365 for now.
it works, but the excel file it becomes too slow when there are a lot bigger list than yours, so if ever you hava another solution I would be very grateful if you share it with us
Thnx Stephane! I did not try this method on much bigger lists. There are a lot of other methods to achieve something similar as this, especially with all the new functions in Excel nowadays. You can easily find them when googling on this subject. Maybe in the future I will make another video about this subject with other methods.
@@rbxexcelvideos I'm trying to find a solution within using VBA, for the moment there are 3 personnes plus you who proposed some solution and it's either too slow after or there are circulate reference error because of cell (adress or contents) formula used
Thank you any way for your answer
No problem, good luck with your search!