Can you do a (=A1) cell ref and have the only the number move when draging horizontal? I tried using (=$A1), but that didn't work.
Here is the formula i am using "=COUNTIFS(RawData!$A$2:$A$1048576, J4,RawData!$M$2:$M$1048576, $A$10)"
I want the Cell "J" to stay and only increase the row #
Last edited by kokapelly; 09-25-2014 at 03:45 PM.
How do you expect the row number to change if you are dragging horizontally.
or are you saying that you want the horizontal movement to be transposed.
If so include the above in your formula.
Please Login or Register to view this content.
Last edited by mehmetcik; 09-25-2014 at 03:50 PM.
I am expecting (want) the row number to change when i drag it horizontally if possible.
The offset will do that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks