Excel - Dragging problem in Indirect Function

April 2018


I have only data in Sheet1 from C2 to C200 and

I am using Indirect function in Sheet2 and when i drag it from C2 to C200 it is showing

only C:2 data in all cell from C2 to C200


I am not able to sort out this problem please help me


You can try this:



Thanks to rizvisa1 for this tip on the forum.
Published by aakai1056. Latest update on April 23, 2010 at 09:30 AM by aakai1056.
This document, titled "Excel - Dragging problem in Indirect Function," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - Search & Display query
Excel - How to sort and delete redundant value?