Hi, everyone
I have a filtered excel sheet, and I would like to use the drag down formula to the filtered rows, like the following format.
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX!$L$2
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX$L$3
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX$L$4
...
This means I want to drag down the formula, so that the number can ascend automatically, but only to the filtered rows. The others should remain blank.
can anyone help me with this?
I have been stuck for 2 hours!
Thank you so much!!!!!
Anna
Bookmarks