• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filtering of data and separate into two worksheets.

VDS

Member
Dear Experts,

I am attaching herewith two excel files. Testing File & Dummy

Testing File contains thee worksheets namely "Data", "Active" and "Closed" in which I have separated the data of "Active" and "Closed" by using array formula /command
I have to use the same formula in the Dummy file where there are larger number of columns. in the dummy file it is "Disposed" and "Active". When I try to copy paste the command, it gives result 0.

Please help me in getting the correct output. In fact this solution has given by some of the experts from Chandoo.org very long back. But cant remember how to apply.

VDS
 

Attachments

vletm

Excel Ninja
VDS
About Your In fact this solution has given by some of the experts from Chandoo.org very long back. But cant remember how to apply.
You could try to do next steps:
#1 Move Your mouse cursor over VDS -text below Your picture

Screenshot 2021-07-14 at 11.02.59.png
#2 Move Your mouse cursor over 384
#3 Push Your mouse's right button down to get menu
#4 Select Open Link in New Tab to see Your previous messages
Screenshot 2021-07-14 at 11.03.23.png
 
Top