Hi, great video with great explanations. Is there a simplified version of this. Say the data you are pulling is just two columns (A:B). The data in those columns are "Products" (A) and "Quantity" (B). The second/new table will show only the products with quantities. So now you are only pulling column A into a new table on a different tab. Is there a simplified version to do that?
Which version of Excel r u using?If the version is Office365, there already is a n inbuilt function viz. FILTER to achieve this kind of dynamic filtering. But if that's not the case an you r using a version lower than this, you will have to resort to this workaround, be in the same tab or another tab. Again referring within tab witnesses some slight improvement as you move into higher versions of Excel. In case there is still something that u want to be assisted kindly mail to offtooffice@gmail.com
Majboor kar diya subscribe karne ko. It actually solved my all time problem.
Glad it helped.
Bhut badiya bhai
Mai sab sikh gya 👌👌
Glad u liked.
I know im late but is there a way to use Column instead of Row?
Very well explained👍
Thanks. Keep watching and sharing.
very good. i like it
Keep watching and sharing for benefits to others as well.
Hi, great video with great explanations. Is there a simplified version of this. Say the data you are pulling is just two columns (A:B). The data in those columns are "Products" (A) and "Quantity" (B). The second/new table will show only the products with quantities. So now you are only pulling column A into a new table on a different tab. Is there a simplified version to do that?
Which version of Excel r u using?If the version is Office365, there already is a n inbuilt function viz. FILTER to achieve this kind of dynamic filtering. But if that's not the case an you r using a version lower than this, you will have to resort to this workaround, be in the same tab or another tab. Again referring within tab witnesses some slight improvement as you move into higher versions of Excel. In case there is still something that u want to be assisted kindly mail to offtooffice@gmail.com
Nice video sir ji 🙏 👍 👌
Keep learning.