ject: Re: $$Excel-Macros$$ How to Drag & get C,D,E,F post A,B...
After A, B, C.Y, Z and then AA, AB and so on - if you are looking for this,
you can use below after putting "A" in A1 -
=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1)
Regards, Abhishek
On F
: 05-Fri-2014 12:34
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ How to Drag & get C,D,E,F post A,B...
After A, B, C.Y, Z and then AA, AB and so on - if you are looking for this,
you can use below after putting "A" in A1 -
=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A
After A, B, C.Y, Z and then AA, AB and so on - if you are looking for
this, you can use below after putting "A" in A1 -
=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1)
Regards, Abhishek
On Fri, May 9, 2014 at 12:21 PM, Amit Desai (MERU)
wrote:
> Dear Friends,
>
>
>
> Please help me wi
Dear Friends,
Please help me with very basic query.
When we have 1 in Cell A1 & 2 in Cell A2, when we drag the data further down
selecting both cells, we get 3,4,5,6,7 etc
However when we do this for cells with A in Cell A1, B in A2, we do not get
C,D,E,F...Any logical Reason? Is there any
