So I want to extract data from a large data set using pivot. But i only want to extract specific data that contains specific word, can i do it with Pivot Table?
Let's say the large data set has 5column. i want to extract all the 5 columns, but only data contains word "SUP" and "C" in column A. Can i do it with PIVOT or is there other alternatives?
Pivot table
-
Are the key words located only in specific columns. If so, you can filter the data using the Filter on the ribbon. Otherwise, provide us with a sample worksheet.
-
Hello thanks for the reply. I already reupdate my question and attached the sample file above. Thankyou
-
Hello,
As Alan said ... you should make your life (and your file...) easier ...:wink:
Attached is a proposal ...
Hope this will help
-
Hello,
Once you have tested the solution ... feel free to share your comments ...
-
-
Thankyouuuuu. It worksss! u make my life easier
-
Glad to hear you have also solved this problem ... !!!
Thanks for your Thanks :smile:
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!