Forum Discussion
Ecxel VBA
NikolinoDE Thanks for the reply, but it doesnt work for me.
I want to replicate the FILTER function in Vba for Excel 2016-2019, as shown in the example below.
If you have any questions please contact me.
At the same time, please describe your plans step by step.
It would be advantageous to know the Excel version (e.g. 2016,16.0.5356.1001), operating system (win, mac, etc.) and storage medium (Sharepoint, OneDrive, hard drive, etc.).
Thank you for your understanding and patience
I can't insert the actual file, because it contains too many sensitive data.
However, it is much close to the example i gave you above.
The plan is to give a value (id as in the example), then the script should see the values of the other fields of that particular id and return a table filtered with those field as criteria. Exactly like the FILTER function in the given example.The Excel version is 2016 and 2019 (can't remember the exact version) running on windows 10. The file used is stored in hard drive.
As i give id number (cell N3), i want to search all the other rows and find ids that have the same product (laptop-HP) and price (100) values with the given id, as shown below. I would also like to do this dynamically in the same table. All of that with VBA.
Thanks in advance.