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
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